请教各路神仙一SQL问题

来源：百度知道 编辑：UC知道 时间：2024/05/26 14:22:09
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
其他都是一些表的字段名称跟完整性约束

创建了一个叫 HR_Attendance 的表
AttendanceID，EmployeeID, CheckMonth,
CheckYear, AllDays, ErrandDays, IllDays,
AffairDays, HolidayDays,
NegaticeDays, LateMinutes, EaryMinutes, OvertimeDays

都是表的属性（列）

其中AttendanceID 为表的主键 ，不能重复的。

创建表[ dbo ] 。 [ HR_Attendance ] （
[ AttendanceID ] [摘要]身份（ 1,1 ）非空，
[员工] [ varchar ] （ 50 ）非空，
[ CheckMonth ] [ varchar ] （ 50 ）空，
[ CheckYear ] [ varchar ] （ 50 ）空，
[ AllDays ] [国际]空，
[ ErrandDays ] [国际]空，
[ IllDays ] [国际]空，
[ AffairDays ] [国际]空，
[ HolidayDays ] [国际]空，
[ NegaticeDays ] [国际]空，
[ LateMinutes ] [国际]空，
[ EaryMinutes ] [国际]空，
[ OvertimeDays ] [国际]空，
约束[ PK_HR_Attendence ]主键集群
（
[ AttendanceID ]学会
）与（ PAD_INDEX =关， STATISTICS_NORECOMPUTE =关， IGNORE_DUP_KEY =关， ALLOW_ROW_LOCKS =对，对ALLOW_PAGE_LOKS = ）在[原]
）在[原]