【正文】 archar](20) COLLATE Chinese_PRC_CI_AS NULL, [參加工作時(shí)間] [datetime] NULL) ON [PRIMARY]建立婚姻表SQL語言的實(shí)現(xiàn)：CREATE TABLE [dbo].[婚姻狀況表]( [員工號(hào)] [char](6) COLLATE Chinese_PRC_CI_AS NOT NULL, [愛人代號(hào)] [char](6) COLLATE Chinese_PRC_CI_AS NOT NULL, [愛人姓名] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [愛人籍貫] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [愛人民族] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [出生日期] [datetime] NULL, [結(jié)婚時(shí)間] [datetime] NULL, [工作單位] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [政治面貌] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [工作職稱] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL) ON [PRIMARY]建立學(xué)歷表SQL語言的實(shí)現(xiàn)：CREATE TABLE [dbo].[學(xué)歷表]( [員工號(hào)] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [學(xué)位證書編號(hào)] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [學(xué)歷] [char](10) COLLATE Chinese_PRC_CI_AS NULL, [專業(yè)] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [畢業(yè)時(shí)間] [datetime] NULL, [畢業(yè)院校] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL) ON [PRIMARY]建立考勤表SQL語言的實(shí)現(xiàn)：CREATE TABLE [dbo].[考勤表]( [員工號(hào)] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [員工姓名] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [日期] [datetime] NULL, [本月天數(shù)] [char](10) COLLATE Chinese_PRC_CI_AS NULL, [公休天數(shù)] [char](10) COLLATE Chinese_PRC_CI_AS NULL, [應(yīng)出勤天數(shù)] [char](10) COLLATE Chinese_PRC_CI_AS NULL, [請(qǐng)假] [char](10) COLLATE Chinese_PRC_CI_AS NULL, [節(jié)假日加班] [char](10) COLLATE Chinese_PRC_CI_AS NULL, [其它加班] [char](10) COLLATE Chinese_PRC_CI_AS NULL) ON [PRIMARY]建立工資表SQL語言的實(shí)現(xiàn)：CREATE TABLE [dbo].[工資表]( [員工號(hào)] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [員工姓名] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [底薪] [int] NULL, [補(bǔ)貼] [int] NULL, [獎(jiǎng)金] [int] N