使用如下办法:
创建表TABLE1
CREATE TABLE [dbo].[TABLE1] (
[col1] [int] IDENTITY (1, 1) NOT NULL,
[col2] [varchar] (10) NULL
) ON [PRIMARY]插入数据,并获取标识列值:
INSERT INTO table1(col2) VALUES ('99')
SELECT @@IDENTITY AS '标识列值'
创建表TABLE1
CREATE TABLE [dbo].[TABLE1] (
[col1] [int] IDENTITY (1, 1) NOT NULL,
[col2] [varchar] (10) NULL
) ON [PRIMARY]插入数据,并获取标识列值:
INSERT INTO table1(col2) VALUES ('99')
SELECT @@IDENTITY AS '标识列值'
同意楼上两位的.