sql server中有一字段,如:
stid int identity (20031201,1) not null
我想在2004年时将其改为
stid int identity (20040101,1) not null
请问这个alter table tablename如何写?
即将其初始值从20031201 改为20040101
...全文
717打赏收藏
sql server中有一字段,如:stid int identity (20031201,1) not null
sql server中有一字段,如: stid int identity (20031201,1) not null 我想在2004年时将其改为 stid int identity (20040101,1) not null 请问这个alter table tablename如何写? 即将其初始值从20031201 改为20040101
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_TABLE2
(
id int NOT NULL IDENTITY (20000101, 1)
) ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_TABLE2 ON
GO
IF EXISTS(SELECT * FROM dbo.TABLE2)
EXEC('INSERT INTO dbo.Tmp_TABLE2 (id)
SELECT id FROM dbo.TABLE2 TABLOCKX')
GO
SET IDENTITY_INSERT dbo.Tmp_TABLE2 OFF
GO
DROP TABLE dbo.TABLE2
GO
EXECUTE sp_rename N'dbo.Tmp_TABLE2', N'TABLE2', 'OBJECT'
GO
COMMIT