createwebshoppedb.sql
来自「这是用ASP+SQL+HTML+XML写的」· SQL 代码 · 共 40 行
SQL
40 行
/* Install WebShoppe database */
set nocount on
USE master
declare @dttm varchar(55)
select @dttm=convert(varchar,getdate(),113)
raiserror('Starting installation of WebShoppe Database at %s ....',1,1,@dttm) with nowait
GO
if exists (select * from sysdatabases where name='WebShoppe')
begin
raiserror('Dropping existing WebShoppe database ....',0,1)
DROP database WebShoppe
end
GO
CHECKPOINT
go
raiserror('Creating WebShoppe database....',0,1)
go
CREATE DATABASE WebShoppe
GO
CHECKPOINT
GO
USE WebShoppe
GO
if db_name() <> 'WebShoppe'
raiserror('Error in installWebShoppe.SQL, ''USE WebShoppe'' failed! Killing the SPID now.'
,22,127) with log
GO
execute sp_dboption 'WebShoppe','trunc. log on chkpt.' ,'true'
execute sp_dboption 'WebShoppe','SELECT INTO/BULKCOPY', 'true'
checkpoint
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?