Write a Query in SQL Server to get the Parameter list of given Store Procedure.

 Posted by Lakhangarg on 11/19/2009 | Category: Sql Server Interview questions | Views: 4848
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 

Comments or Responses

Posted by: Easwaran on: 8/31/2012 | Points: 10
SPs that don't have parameter are returning some values as well. Please do provide correct query.

Login to post response