开发者

Error creating database

开发者 https://www.devze.com 2023-04-06 04:37 出处:网络
I am creating a database by using following schema ...... using microsoft sql server.... CREATE DATABASE /*!32312 IF NOT EXISTS*/`stacks`/*!40100

I am creating a database by using following schema ...... using microsoft sql server....

 CREATE DATABASE /*!32312 IF NOT EXISTS*/`stacks`/*!40100 
 DEFAULT CHARACTER SET utf8 *开发者_如何学JAVA/;(Line 15)

 USE `stacks`;

/*Table structure for table `answers` */

Got An error like this ...while executing , i dont know....

 Error :  Msg 102, Level 15, State 1, Line 15
      Incorrect syntax near '`'.

would any one pls help on this.....

Many Thanks in advance ....


Did you look up SQL Server CREATE DATABASE and identifier syntax?

All you need is CREATE DATABASE stacks;

Your code is for MySQL


It looks like your syntax is from MySQL. Why do you have back-ticks and "default character set"? This is not SQL Server syntax. Please see the SQL Server docs for CREATE DATABASE: http://msdn.microsoft.com/en-us/library/ms176061.aspx

0

精彩评论

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