Re: 【求助】一个SQL Server问题～～

Article View: cn.bbs.comp.database

Article #1692

Back to cn.bbs.comp.database Previous Next

#1692

From: haohao
Date: Wed, 14 Dec 2005 03:44

33 lines
2577 bytes

�㶫�����ش�����, ������ talk.politics.china������ ...

�����÷����� news://freenews.netfront.net/

.

"һ�����" wrote:

> ��ͬʱupdate a �� b��

>
> �� �� goldeagle@bbs.cqupt.edu.cn-SPAM.no (����ӥ) �Ĵ������ᵽ: ��
> : ��������a��b������Ҫ��a�����ֶ�a1��b�����ֶ�b1��ȵ��е�a2�ֶε�ֵ����b2������
> : ˵a������a1��a2�ֶΣ�b������b1��b2�ֶΣ����ھ���Ҫ����a�����ֶ�a1��b�����ֶ�b1��ȵ��У����Ұ�����a2��ֵ����b2����������SQL�����SQL Server2000�б��?˵��һ�еĵ�һ�����Ÿ������﷨���󣬵�����Access��������������ܹ�ִ�еģ���֪����SQL Server2000��
> �: ���?���ָ���ô������ʵ�����湦�ܣ��������ʾ��лл����
> : ������SQL���
> : update a,b
> : set b.b2=a.a2
> : where a.a1=b.b1
>
> --
> Hey I've been watching you
> Every Little thing you do
>
> [m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 219.228.106.168][m




---
Posted via news://freenews.netfront.net
Complaints to news@netfront.net

Technical Details

Message-ID: <439F953A.BA45F09@hotonil.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!wns13feed!worldnet.att.net!199.218.7.141!news.glorb.com!news.netfront.net!not-for-mail

References: <4LYGEO$bGW@bbs.sjtu.edu.cn>

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,412328e399b5e4ec
X-Google-Attributes: gid101948,public
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!wns13feed!worldnet.att.net!199.218.7.141!news.glorb.com!news.netfront.net!not-for-mail
From: haohao <d.j.y@hotonil.com>
Newsgroups: cn.bbs.comp.database
Subject: Re: 【求助】一个SQL Server问题～～
Date: Wed, 14 Dec 2005 11:44:59 +0800
Organization: http://Hotonil.com (不锈钢)
Lines: 32
Message-ID: <439F953A.BA45F09@hotonil.com>
References: <4LYGEO$bGW@bbs.sjtu.edu.cn>
Reply-To: ONE.@hotonil.com
NNTP-Posting-Host: 203-67-147-33.adsl.dynamic.seed.net.tw
Mime-Version: 1.0
Content-Type: text/plain; charset=gb2312
Content-Transfer-Encoding: 8bit
X-Trace: adenine.netfront.net 1134531904 76855 203.67.147.33 (14 Dec 2005 03:45:04 GMT)
X-Complaints-To: news@netfront.net
NNTP-Posting-Date: Wed, 14 Dec 2005 03:45:04 +0000 (UTC)
X-Mailer: Mozilla 4.8 [en] (Windows NT 5.0; U)
X-Accept-Language: en

Reply to Parent Message