auto generate code for sp parameters?

Is there an easy way to generate the parameters code for calling stored procedures?

Is there an easy way to generate stored procedure code without having to manually type it in? I've seen 3rd party tools, but I was wondering if there's anything within Sql Server to do it.

I'm using c#, visual studio 2005, sql server 2005.

Thanks,

John

Using Visual Studio, Server Explorer, if I recall correctly, there 'may' be a procedure wizard.|||

I'm unable to locate it, please elaborate on how to find or get it. Do I need an sdk?

John

|||

For the T-SQL code, open SQL Server 2005 Management Studio and go to the Object explorer. Find your stored procedure, right click, and select Script Stored Procedure As > EXECUTE to > New Query Window Editor Window

Make sure to set the values of your variables before running.

For C# in Visual Studio, you might try asking the question again in one of the programming forums.