Creation Script for the usp_EmployeeInsert Stored Procedure : Insert Statement « Transact SQL « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Transact SQL
3. Insert Statement

5>
6>
7> CREATE TABLE Employees
8> (orderid int NOT NULL,
9>  customerid int NULL,
10>  empname varchar(25) NOT NULL,
11>  orderdate Datetime,
12>  salary money NOT NULL);
13> GO
1>
2> CREATE PROC dbo.usp_EmployeeInsert
3>   @orderid    int,
4>   @customerid char(5),
5>   @orderdate  datetime
6> AS
7> INSERT INTO Employees(orderid, customerid, orderdate)
8>   VALUES(@orderid, @customerid, @orderdate)
9> GO
1>
2>
3> drop proc dbo.usp_EmployeeInsert;
4> GO
1>
2> drop table Employees;
3> GO