【SQL开源代码栏目提醒】:本文主要为网学会员提供Users.sql,希望对需要Users.sql网友有所帮助,学习一下!
USE Mis
GO
CREATE TABLE [Users] (
[UserName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[EmpId] [int] NULL ,
[UserPwd] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[UserType] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
(
[UserName]
) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT INTO Users Values('Admin',1,'888888','
系统管理员')
INSERT INTO Users Values('hr',1,'888888','人事专员')
GO