marc.snoeys (5/22/2013)
That's a non-argument because you can't insert two or more records with the VALUES-syntax as well 😉
Like this you mean?
CREATE TABLE #test (
ID INT
)
INSERT INTO #test (ID)
VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)
SELECT * FROM #test AS t
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability