How to Create a Stored Procedure in SQL Server

Hello guys this is the basic way on how to simply Create a Stored Procedure in Sql Server
2005 just follow the Steps that shown on the Image below

Click Database then

then Select your Database Name where do you want to create your Stored Procedure
then

click Programability  then

then Right-Click from the Stored Procedure like shown at the image above then click New 
Stored Procedure

then the default  template will appear like shown above but i create a basic stored procedure
in a simplest way

as you see the Results Command(s) Completed Successful to check your syntax or code just
click Check icon at the tool bar,and after that click Execute

code  will look like this

Create Procedure Save_Tax (@ID_Num varchar(50),
@Tax_F varchar(50),@Tax_T varchar(50),
@Tax_Tot varchar(50)) As
Insert Into Tax_Table
Values(@ID_Num,@Tax_F,@Tax_T,@Tax_Tot)

Happy Coding

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Tags: Database, SQL Server