sp_sproc_columns and Profiler

From the forum:

How to know programmatically about stored procedure parameters, their number and properties if I know its name. I suspect that there is some system procedure to give the answer but do not know.

You can do the following to know about sp parameters:

exec DB_TEST..sp_sproc_columns N'myproc2', 
                               N'dbo', 
                               N'DB_TEST', 
                               NULL, 
                               @ODBCVer = 3

How do I know ? Easily. Open the profiler and simply browse Query Analyzer. You can learn lots of things from there. :)

Related Posts:

• SQL Function for Date Sequences (Version 2.1)
• MSSQL: Some Undocumented Features
• Generate Calendar Dates. Version 2.0
• My howto on sqljunkies
• How to PIVOT Tables in MSSQL 2000
• QA vs VS2003. Debugging stored procedure.
• Year calendar 2004
• Yukon 2005 and Whidbey 2005
• Optional parameters in T-SQL: COALESCE vs. ISNULL vs. IS NULL OR
• MSSQL Reset Identity: TRUNCATE TABLE vs. DBCC CHECKIDENT RESEED