...overflowed an int column��ν��

Article View: cn.bbs.comp.database

Article #1282

Back to cn.bbs.comp.database Previous Next

#1282

From: guoguo
Date: Tue, 09 Oct 2007 13:47

27 lines
1425 bytes

vs2005+sql 2005 express edition +xp

���и������ֶ�,varchar(30)ԭֵ��5050109075,�����޸�Ϊ1111

sql�����

"update personnel set passwd "= this.txtPwd1.Text.ToString() + "where studyn


o=" + stuNo;

�������д���:

The conversion of the varchar value '5050109075' overflowed an int column. M
aximum integer value exceeded.

The statement has been terminated.

�����ò�ѯ������û������. �о�cmd.ExecuteNonQuery();�Զ���stringת��Ϊint,��
�����.

��֪������Ƿ����������������,��ν������?

--
--

[m[1;35m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 219.228.111.159][m

Technical Details

Message-ID: <4WPc1O$bei@bbs.sjtu.edu.cn>

Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!news.neu.edu.cn!bbsnews.sdu.edu.cn!SJTUBBS

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,afc284aa0c8fb43c,start
X-Google-Attributes: gid101948,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!news.neu.edu.cn!bbsnews.sdu.edu.cn!SJTUBBS
From: oleole.bbs@bbs.sjtu.edu.cn (guoguo)
Newsgroups: cn.bbs.comp.database
Subject: ...overflowed an int column����������ν��
Date: 09 Oct 2007 13:47:37 GMT
Organization: ��ˮ˼Դ
Message-ID: <4WPc1O$bei@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1191937608.A

Article View: cn.bbs.comp.database

...overflowed an int column����������ν��

...overflowed an int column��ν��