Sawaf's food for thought...
Documenting Experience!
Wednesday, 28 November 2012
TSQL Insert multiple values using a single insert statement
INSERT INTO
TargetTable (Column1, Column2)
SELECT
'Value1', 'Value1'
UNION
SELECT
'Value2', 'Value2'
UNION
SELECT
Column1, Column2
FROM
SourceTable
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment