Article View: cn.bbs.comp.database
Article #1720����sql��һ����
From: ������
Date: Sun, 25 Dec 2005 11:33
Date: Sun, 25 Dec 2005 11:33
31 lines
1362 bytes
1362 bytes
Ҫ�����ˣ���λ���˿����ҿ���
ijT-SQL���Ƭ�����£�����ÿһ����䣬�Դ�Ϊ��˵��sql server�е����Ĭ
�����������������������
BEGIN TRAN update_authors
Update authors set ����where����
BEGIN TRAN update_titleauthor
Update titleauthor set����where����
If @@error!=0
Begin
ROLLBACK TRAN update_titleauthor
Print 'Failed to update Titleauthor'
End
COMMIT TRAN update_titleauthor
COMMIT TRAN update_authors
Go
--
[m[1;35m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 219.228.117.80][m
Technical Details
Message-ID:
<4LhR1d$aug@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!nntp-server.pubsub.com!bbsnews.sdu.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,702ff7ea13b4b1c9,start X-Google-Attributes: gid101948,public X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!nntp-server.pubsub.com!bbsnews.sdu.edu.cn!SJTU From: freyic.bbs@bbs.sjtu.edu.cn (��ô������) Newsgroups: cn.bbs.comp.database Subject: ����sql��һ���� Date: 25 Dec 2005 11:33:20 GMT Organization: ��ˮ˼Դ Message-ID: <4LhR1d$aug@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1135510359.A Lines: 31