createwebshoppedb.sql

这是用ASP+SQL+HTML+XML写的

	 /*      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