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 + -
显示快捷键?