How to create stored procedure in SQL Server 2005

compad

Hello Friends, How to create stored procedure in SQL Server 2005. Please help me. Thanks in advance. Adarsh

Colin Angus Mackay

CREATE PROCEDURE mySchema.MyProcedure
(
... Parameters go here ...
)
AS
... SQL Code Goes here ...
GO

Recent blog posts: *SQL Server / Visual Studio install order *Installing SQL Server 2005 on Vista *Tip of the Day - SysInternals * Meme My Blog

nelsonpaixao

hi, you have to download some tutorial first ;P

nelsonpaixao@yahoo.com.br

new2pgrmg

Hi Adarsh, Open SQL Server Create a database like "Test" Open that database You will find programability--open it you will find stored prtocedure. Rite click ....select new stored procedure A query window will come paste ur SP and run It will get added to your SP For further questions mai me at jijuanair@gmail.com Hope this helps

compad

Thanks for your reply. can u have anything more. something like data types, how to declare variable, how to check condition. I am aware of Oracle Procedure. Is the same syntax or something different. Please Help me Adarsh

compad

Thanks for your help If you have any link for tutorial. please forward it to me. Thanks Adarsh

Colin Angus Mackay

compad wrote:

If you have any link for tutorial. please forward it to me.

Can you not use a search engine? The search term "SQL Server Tutorial" will probably give you lots of links to helpful websites.

Recent blog posts: *SQL Server / Visual Studio install order *Installing SQL Server 2005 on Vista *Tip of the Day - SysInternals * Meme My Blog

Colin Angus Mackay

compad wrote:

how to declare variable

DECLARE @myVariable int -- or what ever type you want.

compad wrote:

how to check condition

IF @myVariable = 123
BEGIN
... Some SQL Code Here
END
ELSE
BEGIN
... Some other SQL Code here
END

compad wrote:

I am aware of Oracle Procedure. Is the same syntax or something different.

You might want to read the documentation.

Recent blog posts: *SQL Server / Visual Studio install order *Installing SQL Server 2005 on Vista *Tip of the Day - SysInternals * Meme My Blog

compad

Thanks a lot I got it. Adarsh