gpczb_default.sql

机械工业出版社《SQL Server应用开发实例教程》源代码

/*
   2001年4月9日 11:26:12
   User: 
   Server: JERRY
   Database: diskrent
   Application: MS SQLEM - Data Tools
*/

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.gpczb
	DROP CONSTRAINT DF_gpczb_sfshy
GO
CREATE TABLE dbo.Tmp_gpczb
	(
	czbhm int NOT NULL IDENTITY (1, 1),
	gph int NOT NULL,
	ygbh int NOT NULL,
	czrq datetime NOT NULL,
	ghrq datetime NOT NULL,
	sfshy bit NOT NULL,
	yj money NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_gpczb ADD CONSTRAINT
	DF_gpczb_czrq DEFAULT @@dbts FOR czrq
GO
ALTER TABLE dbo.Tmp_gpczb ADD CONSTRAINT
	DF_gpczb_ghrq DEFAULT @@dbts FOR ghrq
GO
ALTER TABLE dbo.Tmp_gpczb ADD CONSTRAINT
	DF_gpczb_sfshy DEFAULT (0) FOR sfshy
GO
SET IDENTITY_INSERT dbo.Tmp_gpczb ON
GO
IF EXISTS(SELECT * FROM dbo.gpczb)
	 EXEC('INSERT INTO dbo.Tmp_gpczb (czbhm, gph, ygbh, czrq, ghrq, sfshy, yj)
		SELECT czbhm, gph, ygbh, czrq, ghrq, sfshy, yj FROM dbo.gpczb TABLOCKX')
GO
SET IDENTITY_INSERT dbo.Tmp_gpczb OFF
GO
DROP TABLE dbo.gpczb
GO
EXECUTE sp_rename N'dbo.Tmp_gpczb', N'gpczb', 'OBJECT'
GO
ALTER TABLE dbo.gpczb ADD CONSTRAINT
	PK_gpczb PRIMARY KEY CLUSTERED 
	(
	czbhm
	) ON [PRIMARY]

GO
COMMIT