RSS feed

How can I run my Stored Procedure in SQL Server 2005

Published by: Guest (8/28/2008)

AUG 28 2008

I wrote a stored procedure but it seems that i never tested that on sql server 2005, this is for the first time i want to run my stored procedure on sql server 2005 but i am confused with the execute command. Should i use CALL or exec?


Why my Order by sql Query not Working in SQL Server 2005 >>

<< To Update Should I Delete before Insert



Name: Rinku

I tried to use the call statement. But its not working. I am fine with the Execute statement. To call a procedure in SQL server 2005 use:
USE Northwind;
GO EXEC Ten_Most_Expensive_Products;
--- The code above will execute the stored procedure Ten_Most_Expensive_Products using the database Northwind.

You can use HTML tags here.
*Code: Please enter the sum of 5+2