Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hardik Doshi T-SQL RE: T-SQL

  • January 16, 2011 at 9:37 pm

    #1274078

    amit_adarsh (1/14/2011)

    I think this part is not correct

    INSERT INTO @student

    VALUES( 'Hardy', 100), ('Rocky', 98), ('Panky', 99)

    it will throw error.

    This is SQL Server 2008 syntax.

    If you want to execute it in SQL 2005 then use the following:

    INSERT INTO @student

    VALUES ( 'Hardy', 100)

    INSERT INTO @student

    VALUES ('Rocky', 98)

    INSERT INTO @student

    VALUES ('Panky', 99)

    Thanks