| 请教各路神仙一SQL问题
|
 减小字体
 增大字体
|
问题：CREATE TABLE [dbo].[HR_Attendance]([AttendanceID] [int] IDENTITY(1,1) NOT NULL,[EmployeeID] [varchar] (50) NOT NULL,[CheckMonth] [varchar] (50) NULL,[CheckYear] [varchar] (50) NULL,[AllDays] [int] NULL,[ErrandDays] [int] NULL,[IllDays] [int] NULL,[AffairDays] [int] NULL,[HolidayDays] [int] NULL,[NegaticeDays] [int] NULL,[LateMinutes] [int] NULL,[EaryMinutes] [int] NULL,[OvertimeDays] [int] NULL,CONSTRAINT [PK_HR_Attendence] PRIMARY KEY CLUSTERED([AttendanceID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOKS=ON)ON[PRIMARY])ON[PRIMARY]这段代码的详细意思是什么呢
建了一个表
表名HR_Attendance
其他都是一些表的字段名称跟完整性约束
如果你对CREATE TABLE [dbo].[HR_Attendance]([AttendanceID] [int] IDENTITY(1,1) NOT NULL,[EmployeeID] [varchar] (50) NOT NULL,[CheckMonth] [varchar] (50) NULL,[CheckYear] [varchar] (50) NULL,[AllDays] [int] NULL,[ErrandDays] [int] NULL,[IllDays] [int] NULL,[AffairDays] [int] NULL,[HolidayDays] [int] NULL,[NegaticeDays] [int] NULL,[LateMinutes] [int] NULL,[EaryMinutes] [int] NULL,[OvertimeDays] [int] NULL,CONSTRAINT [PK_HR_Attendence] PRIMARY KEY CLUSTERED([AttendanceID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOKS=ON)ON[PRIMARY])ON[PRIMARY]这段代码的详细意思是什么呢这个问题有好的意见或
建议，请留言
|
|
[]
[返回上一页]
[打 印]
|
|
|
您当前的位置：
百科371 → 电脑/网络 → 数据库 → 电脑/网络内容
退出登录