how to list the parameters sent into a stored procedure

Copper Contributor

hi 

 

In sybase  you can reference the parameters passed into the procedure , by using this command 

 

%1!

this would pump out the  contents of the first parameter sent into the proc.

for example if the  first  parameter is  @age  =14 

 

I can use  print %1!   to return 14. 

is there a MS SQL equivalent 

 

 

 

0 Replies