insert into table1 (Name) values ('Name 1') select scope_identity()
insert into table1 (Name) output inserted.Id values ('Name 1')