Wednesday, March 14, 2012

Bulk insert using Select

SELECT a,b,c

FROM (VALUES

        (1, '20010101','A'),

        (3, '20020101','B'),

        (5, '20030101','C'),

        (7, '20040101','D'),

        (9, '20050101','E') ) AS SomeTable(a, b,c);

No comments:

Post a Comment