🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #625

Re: ����SQL server 2000�������..

#625
From: ����
Date: Wed, 26 Nov 2008 13:33
24 lines
2461 bytes
�����ڴ洢���A��д��һ��ѭ��, ��ѭ���ڲ����� �洢���B. 

�洢���B����һ������insert���,�����Υ��primary key�Ĵ���. B��������,ȷʵ
�ᱨ��,���Ǻ����ѭ�����ǻ����ִ��.����A�� @@Error���ǵ���0. �����Ҳ�B���쳣
��������A���쳣.


�� �� Dem (Galaxy��VOLUNTEERS��Database) �Ĵ������ᵽ: ��
: ���ڵڶ������⣬����SQL Server 2008�в�����һ�£����ǻ᷵�ش���ģ�������
: ����C����������ͣ����أ�
: Msg 245, Level 16, State 1, Procedure ccc, Line 13
: Conversion failed when converting the varchar value 'aaa' to data type int.
: ��EXEC C֮ǰ�Ļ��ǻ�ִ�еģ����Ҳ��������EXEC C֮��ľͲ������ִ����
: ��֪���Dz�����Ϊ�汾��ϵ����ͷҲû��2000û�������ˡ����������ҹ���05�õ���
: ���Ӧ�ú�08Ҳһ��
: �� �� firbird (����) �Ĵ������ᵽ: ��
: : �Ȳ�����,�����Լ�������һ��..... �õ�����һЩ����,��֪���Ƿ���ȷ...
: :     B��ִ�н��ᱣ��
: .................������ʡ�ԣ�

--
�����ĵ�ץ���Ƕ���Ƥ��,������ˮ; ��ȴֻ�ܽ�����վ������,�����޴�...

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.41.87.226]
Technical Details
Message-ID: <4dDASY$aaZ@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,2d374dfa7c8f71a8
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU
From: firbird.bbs@bbs.sjtu.edu.cn (����)
Newsgroups: cn.bbs.comp.database
Subject: Re: ����SQL server 2000�������..
Date: 26 Nov 2008 13:33:36 GMT
Organization: ��ˮ˼Դ
Message-ID: <4dDASY$aaZ@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1227706210.A
Lines: 23