|
4>
5>
6> CREATE TABLE Employees
7> (orderid int NOT NULL,
8> customerid int NULL,
9> empname varchar(25) NOT NULL,
10> orderdate Datetime,
11> salary money NOT NULL);
12> GO
1>
2> CREATE PROC dbo.usp_EmployeeInsert
3> @orderid int,
4> @customerid char(5) = 'ZZZZZ',
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
|