employee.sql

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

/*
   2001年4月6日 19:30:10
   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.employee
	(
	ygbh int NOT NULL IDENTITY (1, 1),
	ygxm varchar(10) NOT NULL,
	sfz char(10) NULL,
	dh varchar(12) NULL,
	zz varchar(30) NULL,
	jdrq datetime NULL,
	gz money NULL
	)  ON [PRIMARY]
GO
COMMIT