use pubs
gocreate table abc (
cd int
)
goselect * from abcalter table abc alter column cd int identity(1,1)我想将cd列改为自动增长,但是提示语法错误。请问如何解决?
gocreate table abc (
cd int
)
goselect * from abcalter table abc alter column cd int identity(1,1)我想将cd列改为自动增长,但是提示语法错误。请问如何解决?
用sql比较复杂。
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_T_Test
(
id int NOT NULL IDENTITY (1, 1),
name char(10) NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_T_Test ON
GO
IF EXISTS(SELECT * FROM dbo.T_Test)
EXEC('INSERT INTO dbo.Tmp_T_Test (id, name)
SELECT id, name FROM dbo.T_Test TABLOCKX')
GO
SET IDENTITY_INSERT dbo.Tmp_T_Test OFF
GO
DROP TABLE dbo.T_Test
GO
EXECUTE sp_rename N'dbo.Tmp_T_Test', N'T_Test', 'OBJECT'
GO
COMMIT
go
drop table abc
create table abc (
cd int,id int
)
go
alter table abc
drop column cd
alter table abc
add cd int identity(1,100)