如何能获得多个自增长ID?
WZZ 2006-08-15 02:46:57
IF OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE #test
CREATE TABLE #test(col_1 int identity(1, 1) PRIMARY KEY, col_2 int)
INSERT INTO #test VALUES(56)
SELECT SCOPE_IDENTITY() -- 如果是单条记录的插入, 此处可获得当前的自增长ID
INSERT INTO #test
SELECT 1
UNION ALL SELECT 2
UNION ALL SELECT 3
UNION ALL SELECT 4
UNION ALL SELECT 5
-- ? 如果是多条数据同时插入,请问,如何能一次同时,获得这些自增长ID ?