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

Article View: cn.bbs.comp.database

Article #628

Back to cn.bbs.comp.database Previous Next

#628

From: Galaxy��VOLUNTEERS��Database
Date: Wed, 26 Nov 2008 13:50

23 lines
2349 bytes

�Ҳ���һ�£���ȷ�����ѭ��
@@Error�Ķ������£�
Returns the error number for the last Transact-SQL statement executed.
���������ǲ��᷵�ص�
�� �� firbird (����) �Ĵ������ᵽ: ��
: �����ڴ洢���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֮��ľͲ������ִ����
: .................������ʡ�ԣ�

--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

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

Technical Details

Message-ID: <4dDB1e$ayb@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!feeder.erje.net!newsfeed.straub-nv.de!feeder1.news.weretis.net!newsfeeder.dynfx.net!weretis.net!newsfeed.datemas.de!news.isoc.lu!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!g2news1.google.com!news2.google.com!news.glorb.com!feeder.erje.net!newsfeed.straub-nv.de!feeder1.news.weretis.net!newsfeeder.dynfx.net!weretis.net!newsfeed.datemas.de!news.isoc.lu!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database)
Newsgroups: cn.bbs.comp.database
Subject: Re: ����SQL server 2000�ļ�������..
Date: 26 Nov 2008 13:50:37 GMT
Organization: ��ˮ˼Դ
Message-ID: <4dDB1e$ayb@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1227707224.A

Article View: cn.bbs.comp.database

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

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