Hi,
I Used below Query, But it is getting data of Both parameters which are allowing nulls and Not allowing nulls .Please Help this
SELECTp.name AS Parameter,t.name AS [Type]FROM sys.procedures sp JOIN sys.parameters pON sp.object_id= p.object_id JOIN sys.types tON p.system_type_id = t.system_type_idWHERE sp.name ="yourStoredprocedurename