Answer: Suppose we want to get the name of the parameter for the Store Procedure
Course_Insert_sp then folllowing needs to be executed.
SELECT * FROM sys.parameters D INNER JOIN Sys.Objects O ON O.object_id=D.object_id WHERE O.name='Course_Insert_sp'
Thanks & Regards
Lakhan Pal Garg
Asked In: Many Interviews |
Alert Moderator