Post reply

SQL select query

  • April 2, 2014 at 11:43 am

    #305906

    I see the following select statement in one of the stored procedures on the sql server instance.

    SELECT name,id FROM tflag..grades

    I am thinking that the statement selects data from a table 'grades' in the catalog 'tflag'. But I don't see any catalog with that name on the sql server instance.

    Is there something I am missing in understanding the query.

    Thanks.

  • April 2, 2014 at 1:01 pm

    #1702602

    sql_novice_2007 (4/2/2014)

    I see the following select statement in one of the stored procedures on the sql server instance.

    SELECT name,id FROM tflag..grades

    I am thinking that the statement selects data from a table 'grades' in the catalog 'tflag'. But I don't see any catalog with that name on the sql server instance.

    Is there something I am missing in understanding the query.

    Thanks.

    Sounds like you are a user from another database platform? Welcome to SQL Server if so!

    that naming scheme references another DATABASE and the default SCHEMA for that user. If you go to tflag database you may see a table such as dbo.grades, where dbo is the default schema that most objects wind up under.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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