insert一条记录返回自增长id

建表

CREATE TABLE [dbo].[Test1](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [name] [nvarchar](330) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

sql语句

insert  into  test1 (name) values ('1')
select @@identity;