/* 1.1_創(chuàng)建PracticeDB1數(shù)據(jù)庫.sql */

set nocount on						/*設(shè)置nocount為ON*/
USE master							/*使用master數(shù)據(jù)庫*/
declare @dttm varchar(55)			/*聲明變量@dttm*/
select  @dttm=convert(varchar,getdate(),113)
raiserror('開始創(chuàng)建PracticeDB1數(shù)據(jù)庫....',1,1,@dttm) with nowait
GO

if exists (select * from sysdatabases where name='PracticeDB1')
begin
  raiserror('刪除已經(jīng)存在的數(shù)據(jù)庫PracticeDB1....',0,1)
  DROP database PracticeDB1
end
GO

CHECKPOINT
GO

raiserror('創(chuàng)建數(shù)據(jù)庫PracticeDB1....',0,1)
GO
   CREATE DATABASE PracticeDB1
GO

CHECKPOINT
GO

USE PracticeDB1
GO

if db_name() <> 'PracticeDB1'
   raiserror('在創(chuàng)建PracticeDB1時錯誤, 使用PracticeDB1失敗.',22,127) with log
GO

execute sp_dboption 'PracticeDB1','trunc. log on chkpt.' ,'true'
execute sp_dboption 'PracticeDB1','SELECT INTO/BULKCOPY', 'true'
checkpoint