开发者

SQLCMD - trying to drop a database with alphanumeric name '14Data' gives Syntax Error

开发者 https://www.devze.com 2023-02-07 03:51 出处:网络
I am using SQL SERVER 2005 Express. I can delete the database from the query analyzer, what you call Mgmt Studio (ssmsee) by providing double quotes to the database name and things get done;

I am using SQL SERVER 2005 Express. I can delete the database from the query analyzer, what you call Mgmt Studio (ssmsee) by providing double quotes to the database name and things get done;

Drop Database "14data" Go

and the db is gone,

but sqlcmd gives error on 14 (Msg 102 Level 15 State 1 Incorrect sysntax n开发者_StackOverflow社区ear 14 ) May be it considers numeric part as some other thing and not the database name, I tried with N'',"", $(), also tried variables and executing correct sql script files (that ran correctly on mgmt studio) but it gives the same error at the exact same place.

Has any1 ever deleted a database with alphanumeric db name from SQLCMD ?


You may be able to enclose it [] brackets.

e.g.

drop database [14data] go


for special characters use [ ] square brackets. It should be used while dealing with keywords,special characters for column names,table names and database names and as well.

Drop Database [14data]
0

精彩评论

暂无评论...
验证码 换一张
取 消