DROP TABLE theTable
CREATE TABLE theTable(
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](20) NULL
)
--获取自增主键
DECLARE @id INT
INSERT INTO theTable([name]) VALUES('张三')
SELECT @id=@@IDENTITY
PRINT @id
SELECT * FROM theTable
--获取上次操作数据条数
SELECT @@ROWCOUNT