Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CALL and EXECUTE

Status
Not open for further replies.

rac2

Programmer
Apr 26, 2001
1,871
US
With SQL Server 7 in Query Analyzer, I can run my stored procedures with CALL but not with exec or execute.

This is the form I must use.

Code:
DECLARE @id INT
{CALL proc_create_TABLE3_row('again','again',@id)}

I have tried several variations on EXEC without success.
What change to the following would make it run?
Code:
DECLARE @id INT
EXEC proc_create_TABLE3_row('again','again',@id)


 
DECLARE @id INT
EXEC proc_create_TABLE3_row 'again', 'again', @id
 
Well, well, well. Thank you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top