Create commands for stored procedures in SQL Server

Create Proc Stored Procedure name

（

@ Parameter 1 parameter type,

@ Parameter 2 parameter type,

...--the last line of arguments, don't add a comma, the comma means that there are parameters behind it .

）

As

SQL commands to execute

GO

Cases:

A stored procedure that inserts data into the department table in the example database (which has id,name,direc,note parameters in the table):

Use Example

GO

Create Proc Pro_department_insert--Creating a stored procedure named Pro_department_insert

(--Parameter list

@ID int,

@Name varchar (30),

@Direc varchar (10),

@Note varchar--there 's no comma here.

）

As

Insert into department VALUES (@ID, @Name, @Direc, @Note)

GO

Create commands for stored procedures in SQL Server