CATEGORIES
Acer
AMD
Apache
Apple
ASP
Business Object
Compaq
Crystal Reports
CSS
Database
Dell
DOT NET
Fujitsu
Gateway
Google
HP
HTML
IBM
IIS
Intel
Java
Mainframe
Microsoft
Networking
Oracle
SAP
SEO
Sony
SQL Server
Testing
Tomcat
Toshiba
Ubuntu
Visual Basic
Web Hosting
Windows
How can I run my Stored Procedure in SQL Server 2005
Published by: Guest (8/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
- SQL Query to Copy and Insert a Record from Same Table
- SQL Join Query for Microsoft Access Database
- What is the use of nolock condition in SQL Query
- when to use cast and when to use convert operator in SQL
- How can I run my Stored Procedure in SQL Server 2005
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.