create table personinfo([id] [char] (8) not null, [name] [varchar] (10) collate Chinese_PRC_CI_AS not null,
[sex] [char] (2) collate Chinese_PRC_CI_AS null, [contact_id] [char] (3) collate Chinese_PRC_CI_AS not null)
on [primary]
go
create table contact([contact_id] [char] (3) collate Chinese_PRC_CI_AS not null, [office_phone] [varchar] (13) collate
Chinese_PRC_CI_AS not null , [mobile_phone] [char] (11) collate Chinese_PRC_CI_AS null , [address] [varchar] (30)
collate Chinese_PRC_CI_AS NULL , [email] [varchar] (30) collate Chinese_PRC_CI_AS NULL ) ON [PRIMARY]
GO
INSERT INTO personinfo VALUES('00202010' , '戴志誠' , '男' ,'00')
go
INSERT INTO personinfo VALUES('30010265' , '鍾貞' , '女' , '210' )
go
insert into personinfo values ('54024561' , '楊武' , '男' , '245' )
go
insert into contact values ( '001' , ' 87542145' ,'13554021456', '武漢市武昌區134號' , '[email protected]')
go
insert into contact values(' 210 ' ,' 62314522' ,'13556021454' , ' 武漢市武昌區523號' , '[email protected]')
go
insert into contact values('245' , '87541235' , '13554021458' ,'武漢市武口區634號' , '[email protected]')
go
總提示 " insert into contact values(' 210 ' ,' ......"有錯
Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.
3個中第2個怎麼就會錯??我錯的有些難過啊 !!!
[sex] [char] (2) collate Chinese_PRC_CI_AS null, [contact_id] [char] (3) collate Chinese_PRC_CI_AS not null)
on [primary]
go
create table contact([contact_id] [char] (3) collate Chinese_PRC_CI_AS not null, [office_phone] [varchar] (13) collate
Chinese_PRC_CI_AS not null , [mobile_phone] [char] (11) collate Chinese_PRC_CI_AS null , [address] [varchar] (30)
collate Chinese_PRC_CI_AS NULL , [email] [varchar] (30) collate Chinese_PRC_CI_AS NULL ) ON [PRIMARY]
GO
INSERT INTO personinfo VALUES('00202010' , '戴志誠' , '男' ,'00')
go
INSERT INTO personinfo VALUES('30010265' , '鍾貞' , '女' , '210' )
go
insert into personinfo values ('54024561' , '楊武' , '男' , '245' )
go
insert into contact values ( '001' , ' 87542145' ,'13554021456', '武漢市武昌區134號' , '[email protected]')
go
insert into contact values(' 210 ' ,' 62314522' ,'13556021454' , ' 武漢市武昌區523號' , '[email protected]')
go
insert into contact values('245' , '87541235' , '13554021458' ,'武漢市武口區634號' , '[email protected]')
go
總提示 " insert into contact values(' 210 ' ,' ......"有錯
Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.
3個中第2個怎麼就會錯??我錯的有些難過啊 !!!
解决方案 »
- 一个大数据量处理的问题,高手请指教
- 关于复合排序的sql语句问题
- 如何将这两个值组合到一起?
- 关于导入导出数据后所有原来自动编号(标识)列都变成非自动编号(非标识)了?
- 求救:如何在win2003 Server上安装SQL server 2000?
- 求助!一个关于字符串的查询语句!急!非常感谢,小女子在此先谢了!
- ODBC连接远程SQL SERVER时出现的错误?
- 透明的问题?(对我很重要)
- SQL SERVER7清除日志(TRUNCATE LOG)如何用SQL 语句实现,在线等待!!!
- 为什么我的nvarchar(255)型查不到数据?
- 数字保留两位小数点在SQL怎么做?
- 一次错误操作,把EXCEL 中部分数据改掉了,请问有什么办法恢复啊?
这一行有错,第二列前面多了个空格,超出了长度,所以插不进去
The statement has been terminated.
字串或二進制數據可能被截斷
這個陳述被終止明顯的溢位錯誤啊 值與字段定義不一樣