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

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
|||

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

|||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
|||

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

|||

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

|||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