• Gopinath Srirangan (3/22/2011)


    And are you sure this below code executed successfully in 2005 ?

    insert into #test values

    ('1','A'),

    ('','B')

    Thanks

    It will not work in 2005. That's the server I use daily and I wish this syntax would work because it could simplify my job significantly when inserting a bunch of values manually.