Chakri P

Chakri P

  • NA
  • 13
  • 3.6k

Need a query which gets all the Parameters from Procedure

Feb 1 2014 8:48 AM

Hi,

I Used below Query,
 
But it is getting data of Both parameters which are allowing nulls and Not allowing nulls .Please Help this

SELECT
p.name AS Parameter
,t.name AS [Type]
FROM sys.procedures sp JOIN sys.parameters p
ON sp.object_id= p.object_id JOIN sys.types t
ON p.system_type_id = t.system_type_id
WHERE sp.name ="yourStoredprocedurename


Answers (10)