You can get the list of parameters for Stored procedure in two ways:
Solution 1
SELECT * FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME = 'SP_TempProduct'
Solution 2
SELECT * FROM SysColumns WHERE ID = OBJECT_ID('SP_TempProduct')
Solution 1
SELECT * FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME = 'SP_TempProduct'
Solution 2
SELECT * FROM SysColumns WHERE ID = OBJECT_ID('SP_TempProduct')
No comments:
Post a Comment