创建SQL 出现的这是什么错误?
代码如下:
create database XSDLeaveMessage
use master
go
create database LeaveMessage
on primary
(
name='DBcar_data',
filename='G:\XSD\LeaveMessage_data.mdf',
size=5mb,
filegrowth=1mb
)
log on
(
name='DBcar_log',
filename='G:\XSD\LeaveMessage_LOG.ldf',
size=2mb,
filegrowth=1mb
)
go
////////////////////////////////////下面就是有问题的代码了//////////////////////////
use LeaveMessage
go
if exists (select * from sysobjects where name='xuser')
drop table xuser
create table xuser
{
XSD_User char(10) not null,
XSD_UserPassword char(18) not null,
XSD_UserSex int not null,
XSD_UserQQ char(15),
XSD_UserMail char(20),
XSD_UserRemark char(40)
}
go
/////////////////////////////////////////////
错在哪里了呢?系统反馈错误是[Microsoft][ODBC SQL Server Driver]语法错误或违反访问规则