users.sql

来自「ASP+SQL Server网络应用系统开发与实例」· SQL 代码 · 共 12 行

USE UserMan
GO
CREATE TABLE Users
( UserId	Int Primary Key IDENTITY,
 UserName     	Varchar(50) NOT NULL,
 UserPwd      	Varchar(50) NOT NULL, 
 Ename     	Varchar(50),
 Email      	Varchar(50)
)
GO
INSERT INTO Users (UserName, UserPwd, Ename, Email) VALUES('Admin', 'Admin', '', '')
GO