Browse by Tags

How do I find the parameters for a specified stored procedure or function?

Published 10 December 7 5:21 PM | SSQA.net

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...

Filed under: sql server, function, stored procedure, tsql, schema, parameter

Ways to make best use of INFORMATION_SCHEMA Views - Stored procedures & Functions?

Published 15 October 7 7:59 AM | SSQA.net

How many of you took help from using INFORMATION_SCHEMA views in SQL Server? Have you ever wondered in returning the informaiton of a Stored procedure or function, you may be thinking using SP_HELPTEXT would get you. Parts of the solution is yes with...

Filed under: sql server, function, system, stored procedure, tsql, best practice, information schema, views, triggers