¼òµ¥sqlÓï¾ä - MS-SQL Server / »ù´¡Àà
ÐèÇóÈçÏÂ
Á½Õűí
create table A
(
idcard varchar(20),
aa varchar(20),
bb varchar(30)
)
create table B
(
idcard varchar(20),
aa varchar(20),
bb varchar(30)£¬
cc varchar(30)
)
ÏÖÔÚ¸ù¾Ýidcard Ïàͬ£¬ÓÃA±íÖÐaa,bb×ֶθüÐÂB±íÖÐaa£¬bb×Ö¶Î
лл°ïæ
SQL code:
update b set b.aa=a.aa,b.bb=a.bb
from b
join a on a.idcard=b.idcard
SQL code:
update b set b.aa=a.aa,b.bb=a.bb
from a where a.idcard=b.idcard
update b set b.aa=a.aa,b.bb=a.bb from a,b where a.idcard=b.idcard
SQL code:
create table A
(
idcard varchar(20),
aa varchar(20),
bb varchar(30)
)
insert into A
select 1,'333','333333'
create table B
(
idcard varchar(20),
aa varchar(20),
bb varchar(30),
cc varchar(30)
)
insert into B
select 1,'222','2','22'
update b set
aa=(select aa from a where idcard =b.idcard)
,bb=(select bb from a where idcard =b.idcard)
from b
select *from B
idcard
Ïà¹ØÎÊ´ð£º
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä
Id value state dattime
101 32.3 0 ......
ÏÂÃæÊÇXML³õʼÎļþÄÚÈÝ
XML code:
<upd:Update xmlns:lar="http://schemas.microsoft.com/msus/2002/12/LogicalApplicabilityRules" xmlns:cmd="http://schemas.microsoft.com/msus/2002/12/Up ......