Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ÇëÎÊsql anywhereÐÐËøµÄÓï·¨£¿

2 posts in iAnywhere General Discussion (Chinese) Last posting was on 2004-02-13 17:12:35.0Z
softqiu Posted on 2004-02-10 01:55:47.0Z
From: "softqiu" <softqiu@hotmail.com>
Newsgroups: ianywhere.public.chinese.general
Subject: ÇëÎÊsql anywhereÐÐËøµÄÓï·¨£¿
Lines: 3
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 218.72.24.44
Message-ID: <40283cae@forums-2-dub>
X-Original-Trace: 9 Feb 2004 18:06:38 -0800, 218.72.24.44
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Feb 2004 17:37:59 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Feb 2004 17:55:47 -0800
X-Trace: forums-1-dub 1076378147 10.22.108.75 (9 Feb 2004 17:55:47 -0800)
X-Original-Trace: 9 Feb 2004 17:55:47 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:255
Article PK: 466

ÇëÎÊsql anywhereÐÐËøµÄÓï·¨£¿


Raymond Kwong Posted on 2004-02-13 17:12:35.0Z
From: "Raymond Kwong" <raymond.kwong@sybase.com>
Newsgroups: ianywhere.public.chinese.general
References: <40283cae@forums-2-dub>
Subject: Re: ÇëÎÊsql anywhereÐÐËøµÄÓï·¨£¿
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: rkwong-pc.sybase.com
Message-ID: <402d081a$1@forums-2-dub>
X-Original-Trace: 13 Feb 2004 09:23:38 -0800, rkwong-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Feb 2004 08:54:25 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Feb 2004 09:12:35 -0800
X-Trace: forums-1-dub 1076692355 10.22.108.75 (13 Feb 2004 09:12:35 -0800)
X-Original-Trace: 13 Feb 2004 09:12:35 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:256
Article PK: 405

ÐÐËøÊÇûÓÐʲôÌض¨Óï·¨¿ÉÑԵġ£

Ö»Òª¶Ô±íÄÚµÄÐнøÐÐ×ÊÁϸü¸ÄµÄÊÂÎñ£¬±»¸ü¸ÄµÄÐоͻá¸øËø×Å£¬Ö±µ½ÊÂÎñÒÔCOMMIT»ò
ROLLBACKÖÕ½áΪֹ¡£

Èç¹ûÎҵıí½ÐA£¬ ÓÐpkidºÍcolÁ½¸öÁÐ, ¿ÉÒÔ¿´¿´ÏÂÃæµÄÀý×Ó£º

BEGIN

declare colvar varchar(256);


.....

SELECT col into colvar from A where pkid = some_value;

UPDATE A set col = colvar;
.....

END

"softqiu" <softqiu@hotmail.com> wrote in message
news:40283cae@forums-2-dub...
> ÇëÎÊsql anywhereÐÐËøµÄÓï·¨£¿
>
>