I wanna to use the output parameter in stored procedure.
how can i declare, retrive and execute that procedure and get the output parameter...
quote:Originally posted by khtan
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'your_sp' AND type = 'P')
DROP PROCEDURE your_sp
I wanna to check the strored procedure.
Is it already exist
if yes then drop
Separate names with a comma.