installdb.sql

来自「计算机实用技术 图书管开发系统 好的软件工程开发系统资料整理」· SQL 代码 · 共 31 行

USE master
GO

EXEC sp_addlogin 'BlueHillASPUser', 'Password01', 'BlueHill'
EXEC sp_addlogin 'BlueHillWinUser', 'Password01', 'BlueHill'
GO

IF DB_ID('BlueHill') IS NOT NULL BEGIN
    DROP DATABASE BlueHill
END
GO


use master
GO
create database BlueHill
GO

RESTORE DATABASE BlueHill 
   FROM DISK = 'c:\Case\BlueHill.bak'
GO

use BlueHill
GO

EXEC sp_change_users_login 'Update_One', 'BlueHillASPUser', 'BlueHillASPUser'
EXEC sp_change_users_login 'Update_One', 'BlueHillWinUser', 'BlueHillWinUser'
GO