What will be the output of below T-SQL?

  • What will be the output of below T-SQL?

    SELECT IndexName = [Name],

     RowCount = [RowCnt]

    FROM Pubs.dbo.SysIndexes

    WHERE 1=2

  • Server: Msg 156, Level 15, State 1, Line 2

    Incorrect syntax near the keyword 'RowCount'

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply