Browse by Tags

Quick and simple way to know the stored procedures parameters using TSQL

Published 8 July 8 6:13 AM | SSQA.net

As you may be aware that you can pass parameters to the stored procedure when you have the selection of data requirement such as stored procedure with data type,length, parameter position and also the mode of parameter (Input or Output). Using INFORMATION_SCHEMA...

Filed under: sql server, stored procedure, tsql, information schema, parameter, views

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