employee2.sql

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

/*
   2001年4月9日 10:12:13
   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.Tmp_employee
	(
	ygbh int NOT NULL IDENTITY (1, 1),
	ygxm varchar(10) NOT NULL,
	sfz char(15) NOT NULL,
	dh varchar(12) NULL,
	zz varchar(30) NULL,
	jdrq datetime NULL,
	gz money NULL
	)  ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_employee ON
GO
IF EXISTS(SELECT * FROM dbo.employee)
	 EXEC('INSERT INTO dbo.Tmp_employee (ygbh, ygxm, sfz, dh, zz, jdrq, gz)
		SELECT ygbh, ygxm, sfz, dh, zz, jdrq, gz FROM dbo.employee TABLOCKX')
GO
SET IDENTITY_INSERT dbo.Tmp_employee OFF
GO
DROP TABLE dbo.employee
GO
EXECUTE sp_rename N'dbo.Tmp_employee', N'employee', 'OBJECT'
GO
ALTER TABLE dbo.employee ADD CONSTRAINT
	PK_employee PRIMARY KEY CLUSTERED 
	(
	ygbh
	) ON [PRIMARY]

GO
COMMIT