Procedure with default parameter value : Parameter « Procedure Function « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Procedure Function
3. Parameter

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