3VL – SQL Server Development

Basic Stored Procedures are incredibly simple.

If you write the following query:

SELECT Column1, Column2 FROM Table1

The equivilent stored procedure would be:

CREATE PROCEDURE StoredProcedure
AS
SELECT Column1, Column2 FROM Table1
GO

To call it simply type:

EXEC dbo.StoredProcedure

And execute.

This entry was posted on Monday, April 19th, 2010 at 4:56 pm and is filed under Beginning SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.