how can i use The "Use Database" statement >>>

Hot Topic

DB Mirroring Monitor and querying the "other" db?
conditional formatting - noob question
Problem with multi-valued parameters since SP1
Creating a View with detailed informations
SSIS SqlDumper Output
resize the multi select drop down
how to work with link server in SSIS
How reliable is Microsoft's type4-JDBC driver for MsSQL Server????
sql express on server 2003 and vb6 program
print blank page

SQL Server

Backup of databases within SQL Server 2005 Express
Help with Case Statement
How to conditionally sum a subtotal ?
Database locking issue
Cannot print landscape
Will lost update occur if transaction isolation level set to SNAPSHOT?
OLE DB Command Error SSIS
View with SELECT * doesn't pickup new columns in table
Cache plan different using sp_prepare and sp_executesql.
asp.net confgiguration tool. tool keeps timing out

how can i use The "Use Database" statement >>>

the question is how to use use database statement if

the name of the database contain spaces

please help me

Thanks




Answer this question

how can i use The "Use Database" statement >>>

  • KC k_cheung

    Insert Into [My DB].MyTable(No) values (6)



  • net34

    why all this my friend !!

    don't exaggerate

    i'm tried to write the following statement before :

    Insert Into [My DB].MyTable(No) values 6

    and the compiler refuse the statement ..

    so i send for help



  • flixxx

    If I offended you, please accept my apologies!
    My links were intended only to be fun, nothing more. They are neither related to you nor your question.
    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de


  • E. Woods

    CREATE DATABASE [I SHALL NOT USE BLANKS IN ANY OBJECT NAME]
    GO
    USE [I SHALL NOT USE BLANKS IN ANY OBJECT NAME]
    SELECT * FROM
    INFORMATION_SCHEMA.TABLES
    USE Master
    GO
    DROP DATABASE [I SHALL NOT USE BLANKS IN ANY OBJECT NAME]
    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de


  • Karen Gayda

    Frank Kalis wrote:
    CREATE DATABASE [I SHALL NOT USE BLANKS IN ANY OBJECT NAME]
    GO
    USE [I SHALL NOT USE BLANKS IN ANY OBJECT NAME]
    SELECT * FROM
    INFORMATION_SCHEMA.TABLES
    USE Master
    GO
    DROP DATABASE [I SHALL NOT USE BLANKS IN ANY OBJECT NAME]
    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de

    thats too funny! I picture bart writing that on the blackboard in a future episode of The Simpsons



  • fiza

    Unfortunately you can't add images here in the fora, but I believe you mean this one
    http://www.insidesql.de/images/stories/google_bart.gif

    But I think, this one's also pretty cool
    http://www.insidesql.de/images/6thsense.jpg
    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de


  • how can i use The "Use Database" statement >>>
Answer this question