CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Vikram Bose
Vikram Bose

Reputation: 3365

Error when creating database name using full of number in SQL Server 2008 R2

Create a database name using string, database will create successfully.

Example : 

if db_id('Database1') is null create database Database1

Command(s) completed successfully.

But create database name using full of number, it having a problem

Example : 

if db_id('1234567890') is null create database 1234567890

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '1234567890'.

Is anything wrong in my query?

Upvotes: 4

Views: 851

Answers (2)

Abe Baehaki
Abe Baehaki

Reputation: 61

You can also use double quote

IF DB_ID('1234567890') IS NULL CREATE DATABASE "1234567890"

Upvotes: 4

Devart
Devart

Reputation: 121902

Try this one -

IF DB_ID('1234567890') IS NULL 
    CREATE DATABASE [1234567890]

Upvotes: 5

Related Questions