Some Problems With Output Parameters In Stored Procedures

I have written a simple C# console application that create my own Stored Procedures


the code is here


----------------------------------------------------------------------------





static void Main(string[] args)


{


SqlConnection cn;


string strSql;


string strConnection;


SqlCommand cmd;


strConnection="server=(local);database=Northwind;integrated security=true;";


strSql="CREATE PROCEDURE spmahdi @CustomerID nchar(5) @counter int OUTPUT AS SELECT OrderID, OrderDate,RequiredDate,ShippedDate FROM Orders WHERE CustomerID = @CustomerID ORDER BY OrderID SET @counter=@@rowcount";


cn=new SqlConnection(strConnection);


cn.Open();


cmd=new SqlCommand(strSql,cn);


cmd.ExecuteNonQuery();


cn.Close();


Console.WriteLine("Procedure Created!");


}





------------------------------------------------------------------------------------


but it has some errors becuase of my strSql


strSql="CREATE PROCEDURE spmahdi @CustomerID nchar(5) @counter int OUTPUT AS SELECT OrderID, OrderDate,RequiredDate,ShippedDate FROM Orders WHERE CustomerID = @CustomerID ORDER BY OrderID SET @counter=@@rowcount";


I mean in creating the stored procedure


if i delete the Output parameter from my stored procedure


and my strSql would be somethimg like this


strSql="CREATE PROCEDURE spmahdi @CustomerID nchar(5) AS SELECT OrderID, OrderDate,RequiredDate,ShippedDate FROM Orders WHERE CustomerID = @CustomerID ORDER BY OrderID ";


There will be no errors


I use Visual Studio.NET 2003(full versoin)and MSDE(not Sql Server)


Could someone help me solve this problem?


Thanks and Regards.