22,209
社区成员
发帖
与我相关
我的任务
分享
/* 为了防止任何可能出现的数据丢失问题,您应该先仔细检查此脚本,然后再在数据库设计器的上下文之外运行此脚本。*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
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
GO
CREATE TABLE dbo.Tmp_Sale
(
Id int NOT NULL IDENTITY (1, 1),
SaleTime datetime NOT NULL,
Name varchar(16) NOT NULL
) ON partschSale(SaleTime)
GO
SET IDENTITY_INSERT dbo.Tmp_Sale ON
GO
IF EXISTS(SELECT * FROM dbo.Sale)
EXEC('INSERT INTO dbo.Tmp_Sale (Id, SaleTime, Name)
SELECT Id, SaleTime, Name FROM dbo.Sale WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_Sale OFF
GO
DROP TABLE dbo.Sale
GO
EXECUTE sp_rename N'dbo.Tmp_Sale', N'Sale', 'OBJECT'
GO
COMMIT