Create stored procedure in SQL Server
<p>I am trying to create a stored procedure that will take an <code>ORDER BY &lt;Country&gt;</code> as a parameter to return the query order by that column which is country. What I have created so far is kind of rough, any help would be appreciate! </p>



<pre><code>USE AdventureWorks2014
GO

CREATE PROCEDURE dbo.uspSort @CCountry nvarchar(15) 
AS 
    SELECT
        ContactName, CompanyName, Region, Country
    FROM 
        dbo.Customers
    ORDER BY 
        Country 
GO 
</code></pre>