Post reply

how to get current db in query analiser?

  • June 9, 2004 at 8:12 am

    #108691

    example

    declare @curent_db varchar(255)

    select @curent_db=???

    execute_sql "selec * from  " + @curent_db + ".dbo.sales "

     

     

  • June 9, 2004 at 9:29 am

    #509676

    This isn't really the right forum for this question but...

    SELECT DB_NAME()

    -----
    JL

  • June 9, 2004 at 11:10 am

    #509692

    Good  thank  , bien gracias , tratare de buscar bien el for

  • June 9, 2004 at 1:59 pm

    #509728

    As James pointed out, this really isn't the proper forum. The Question of the Day (QOD) forum is is strictly for discussing the Question of the Day. The QOD is a daily 'test' question that can be found at Resourses>Question of the Day.

    Just wanted to let you know.

    -SQLBill

Viewing 4 posts - 1 through 3 (of 3 total)

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