CATEGORIES
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?
Most Popular Articles
- How can I run my Stored Procedure in SQL Server 2005
- SQL Join Query for Microsoft Access Database
- What is the use of nolock condition in SQL Query
- How can I Truncate my Database Log to Reduce the Size
- when to use cast and when to use convert operator in SQL
Why my Order by sql Query not Working in SQL Server 2005 >>
<< To Update Should I Delete before Insert
COMMENT
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:
EXEC or EXECUTE. eg.
USE Northwind;
GO EXEC Ten_Most_Expensive_Products;
GO
--- The code above will execute the stored procedure Ten_Most_Expensive_Products using the database Northwind.