求一个insert语句。。。。。等待ing!
我向一个存在外健的表中插如数据:
create table users
(
Uid int identity(1,1) primary key not null,
Uname varchar(15) not null,
Upassword varchar(10) not null,
Uemail varchar(20) not null,
Usex bit default(1),
Uclass int ,
Uremark varchar(20) not null,
UragData datetime not null,
Ustate int default(0),
Upoint int default (20) not null,
)
insert into users(Uname,Upassword,Uemail,UragData,Uremark,Upoint) values ('Janytue' , '1','adf@163.com','1987-2-5','艰苦法拉第撒酒风似的',50)
insert into users(Uname,Upassword,Uemail,UragData,Uremark,Upoint) values ('Tomen' , '2','adf@163.com','1987-4-5','感到反光镜忽然台',45)
insert into users(Uname,Upassword,Uemail,UragData,Uremark,Upoint) values ('Fancey' , '1','dfae@163.com','2000-2-5','饿饭四大皆空',90)
select * from users
create table bbsSection
(
Sid int identity (1,1) not null ,
Sname varchar(32) not null,
SmasterID int not null foreign key references users(Uid),
Sprofile varchar(50) ,
SclickCount int ,
StopiCount int,
)
insert into bbsSection (Sname,SmasterID,Sprofile,SclickCount,StopiCount) values
('java技术',3,'包含了J2SE,J2ME,基础类',500,10)
就报出了错误:
服务器: 消息 8152,级别 16,状态 9,行 1
将截断字符串或二进制数据。
语句已终止。
求教,怎么解决?