SQL Server数据库DataRelation的应用示例详解
作者:域名 来源:数据库 浏览: 【大中小】 发布时间:2025-11-05 06:25:26 评论数:
复制create table LeaveType ( PKID int identity(1,据库解1), TypeName nvarchar(50) null, CurState smallint not null default 0, constraint PK_LEAVETYPE primary key (PKID) ) go create table Leave ( PKID int identity(1,1), Title nvarchar(50) null, Reason nvarchar(254) null, LoginID nvarchar(50) null, LeaveTypeID int , DepartID int null, EmployeeID int null, AddTime datetime null, BeginTime datetime null, EndTime datetime null, TBeginDate datetime null, TEndDate datetime null, Remark nvarchar(1000) null, ModUser nvarchar(50) null, ModTime datetime null, CurState smallint not null default 0, constraint PK_LEAVE primary key (PKID) ) go 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.