gpczb.sql

来自「机械工业出版社《SQL Server应用开发实例教程》源代码」· SQL 代码 · 共 42 行

/*
   2001年4月6日 20:45:29
   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
CREATE TABLE dbo.gpczb
	(
	czbhm int NOT NULL,
	gph int NOT NULL,
	ygbh int NOT NULL,
	czrq datetime NOT NULL,
	ghrq datetime NOT NULL,
	sfshy char(10) NOT NULL,
	yj money NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.gpczb ADD CONSTRAINT
	DF_gpczb_sfshy DEFAULT 0 FOR sfshy
GO
ALTER TABLE dbo.gpczb ADD CONSTRAINT
	PK_gpczb PRIMARY KEY CLUSTERED 
	(
	czbhm
	) ON [PRIMARY]

GO
COMMIT