|
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
|