T-SQL获取自增主键

    xiaoxiao2022-07-12  116

    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

     

    最新回复(0)