users.sql

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

USE Discuss
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),
 Logo	Char(10)
)
GO
INSERT INTO Users (UserName, UserPwd, Ename, Email, Logo) VALUES('Admin', 'Admin', '', '', '1.gif')
GO