Hi SathyJay,
if you want to keep the ID's that are already in the table, you can use the following solution:
create table dbo.IdentityTest (
id int not null,
descript varchar(255) null,
T_date datetime not null
)
Insert into IdentityTest Select 1,'test',GETDATE()
Insert into IdentityTest Select 10,'test',GETDATE()
CREATE TABLE dbo.IdentityTest_TEMP (
id int Identity(1,1) not null,
descript varchar(255) null,
T_date datetime not null
)
SET IDENTITY_INSERT dbo.IdentityTest_TEMP ON
INSERT INTO dbo.IdentityTest_TEMP(id, descript, T_date)
SELECT * FROM dbo.IdentityTest
SET IDENTITY_INSERT dbo.IdentityTest_TEMP OFF
DROP TABLE dbo.IdentityTest
EXEC sp_rename 'IdentityTest_TEMP' ,'IdentityTest'
INSERT INTO dbo.IdentityTest(descript, T_date) VALUES('Test', getdate())
Select * From dbo.IdentityTest
DROP TABLE IdentityTest
Regards
Alexander
-
Proposed as answer by
davidbaxterbrowneMicrosoft employee
Wednesday, November 20, 2013 4:01 PM
-
Unproposed as answer by
SathyJay
Thursday, November 21, 2013 10:58 AM