update SMSBilling_MTv2 set FeeType=SMSBilling_Modules.FeeType,FeeInfo1=SMSBilling_Modules.FeeInfo1,
FeeInfo2=SMSBilling_Modules.FeeInfo2 from SMSBilling_MTv2,SMSBilling_Modules where ModuleID=SMSBilling_Modules.InternalName
FeeInfo2=SMSBilling_Modules.FeeInfo2 from SMSBilling_MTv2,SMSBilling_Modules where ModuleID=SMSBilling_Modules.InternalName
set .............
where A in (select A from 表二 )
SET A = t2.A,B = t2.B,C = t2.C
FROM 表2 t2
WHERE A IN (SELECT A FROM 表2)
UPDATE t1
SET A = t2.A,B = t2.B,C = t2.C
FROM 表1 t1,表2 t2
WHERE t1.A = t2.A
我有个字段是CHAR型的,,但还需要SUM求他的和,,,,怎么办,,,晕死
SELECT SUM(CAST(charCol AS DECIMAL(10,3)) FROM t