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
精彩评论