SQL傳回插入識別欄位的值

--傳回插入識別欄位的值

INSERT Table1 VALUES ('XXX'); SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY];