在insert資料時取得序號欄位值(臨時資料表)
drop table if exists #test_t create table #test_t ( sn bigint, sid nvarchar(50), no nvarchar(50), name nvarchar(50) ) insert into test(sid, no, name) output inserted.sn, inserted.sid, inserted.no, inserted.name into #test_t values('123','1','2') insert into test(sid, no, name) output inserted.sn, inserted.sid, inserted.no, inserted.name into #test_t values('222','1','2') select * from #test_t select * from test