JustinW
asked on
Fake Table
I have read only writes in SQLServer '08;
and was wondering if there wasn't a better way to do this:
and was wondering if there wasn't a better way to do this:
WITH DUMB_TABLE(QUESTION, ANSWER)
AS
(
SELECT 1,2
UNION
SELECT 3,4
UNION
SELECT 5,6
)
SELECT * FROM DUMB_TABLE
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://blog.sqlauthority.com/2008/07/02/sql-server-2008-insert-multiple-records-using-one-insert-statement-use-of-row-constructor/