userlist.sql

来自「东软内部材料（四）asp等相关的教学案例 」· SQL 代码 · 共 39 行

use master
go

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'UserList')
	DROP DATABASE [UserList]
GO

CREATE DATABASE UserList
GO


use UserList
go

CREATE TABLE [dbo].[Users] (
   [UserName] [varchar] (50) NOT NULL ,
   [Password] [varchar] (50) NOT NULL ,
   [BGColor] [varchar] (50) NULL
) ON [PRIMARY]
GO

CREATE PROCEDURE sp_UpdateUser
	@UserName varchar(50),
	@Password varchar(50)
AS
	UPDATE Users
	SET Password = @Password
	WHERE UserName = @UserName
GO


INSERT INTO users (UserName, Password) VALUES ('billjones', 'test')
INSERT INTO users (UserName, Password) VALUES ('marthasmith', 'test')
INSERT INTO users (UserName, Password) VALUES ('joesoap', 'test')
INSERT INTO users (UserName, Password, BGColor) VALUES ('sarahware', '87F8ED9157125FFC4DA9E06A7B8011AD80A53FE1', 'gainsboro')
INSERT INTO users (UserName, Password, BGColor) VALUES ('timtom', 'B12B629561D2CFFC1A73CE996F95D1F529F70BAC', 'lightgreen')
INSERT INTO users (UserName, Password, BGColor) VALUES ('billygoat', '9743367EF85DF9405A17FA9B3523524E8EC33B5E', 'yellow')
GO