• DougieCow (11/23/2010)


    Hardy21 (11/23/2010)


    Try

    INSERT INTO #

    SELECT 'ASDF'

    GO 0

    GO <ZERO> --- SQL doesn't throw any complilation error but when you execute the code, status bar should display: "Query completed with errors".

    Nope, doesn't like the 0 (zero) either.

    I think it is the old version of SQL... further investigation does seem to suggest it.

    I have executed the code against SQL Server 2008 R2.

    Thanks