Shulou(Shulou.com)05/31 Report--

This article mainly introduces how MSSQL modifies the self-increasing column of the existing data table, which has a certain reference value, and interested friends can refer to it. I hope you can learn a lot after reading this article.

Use demo

Go

Create table testid

([ID] [bigint] IDENTITY (1) NOT NULL

Col1 varchar (100)

[TMSTAMP] [timestamp] NOT NULL)

Insert into testid (col1) values ('a')

Insert into testid (col1) values ('b')

Insert into testid (col1) values ('c')

Create table testid2

([ID] [bigint] IDENTITY (1) NOT NULL

Col1 varchar (100)

[TMSTAMP] [timestamp] NOT NULL)

Insert into testid2 (col1) select col1 from testid

Set IDENTITY_INSERT testid2 OFF

Select * from testid2

Thank you for reading this article carefully. I hope the article "how MSSQL modifies the self-adding columns of tables with existing data" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.