CREATE TABLE [dbo].[UserInfo](
[id] [int] IDENTITY(1,1) NOT NULL,
[UserName] [varchar](15) COLLATE Chinese_PRC_CI_AS NULL,
[Password] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[npassword] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[dutyid] [int] NULL,
[dutyname] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[departmentid] [int] NULL,
[departmentname] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[jiaose] [int] NULL,
[jiaosename] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[youxiang] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[department] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[banggongdianhua] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[yidong] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[dianzi] [image] NULL,
[flag] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[canceltime] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
主要是这种表的增加和修改 insert 和update。15元一个。随时可以来。有意向的联系我。Q421228069