Monday 7 October 2013

09. Create a table named LeaveDetail in the AdventureWorks database. The following table shows the structure of the LeaveDetail table.









create table LeaveDetail
(
Name varchar(50)not null,
Reason varchar(100)not null,
Number_of_days int constraint chknoday
check(Number_of_days <3)
)

No comments:

Post a Comment