Browse by Tags

All Tags » schema » stored procedur... » sql server   (RSS)
How do I find the parameters for a specified stored procedure or function?
10 December 07 04:21 PM | SQL Master | 2 Comments   
USE < database_name >; GO SELECT SCHEMA_NAME ( schema_id ) AS schema_name , o . name AS object_name , o . type_desc , p . parameter_id , p . name AS parameter_name , TYPE_NAME ( p . user_type_id ) AS parameter_type , p . max_length , p . precision Read More...