userlist.sql

东软内部材料（四）asp等相关的教学案例

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