Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gopi Sri T-SQL RE: T-SQL

  • March 22, 2011 at 2:52 am

    #1301722

    Gopinath Srirangan (3/22/2011)

    The question is " What is the output of the select statement from the below code

    executed in sql server 10.0.1600 and with default settings " and not in SQL Server 2005 🙂

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

    insert into #test values

    ('1','A'),

    ('','B')

    Thanks

    The Insert statement would definitely not work in 2005. The feature of inserting multiple rows using VALUE caluse is introduced in 2008.