hi dev:
updating the CarbonData Table :
UPDATE A SET (column_name1, column_name2,column_name3) =(select column_name1,
column_name2,column_name3 from B WHERE A.id = B.id );
table B is a mirror table of table A .
The fields in B are updated to table A
I want to do batch updates:
Whether to support updating based on the value of table B [column_name1,
column_name2, column_name3] in B,
for example, when B.column_name1 == '' , no update operation is performed.
when B.column_name1 !='', update operation is performed.
________________________________
neusoft TSD salute
---------------------------------------------------------------------------------------------------
Confidentiality Notice: The information contained in this e-mail and any
accompanying attachment(s)
is intended only for the use of the intended recipient and may be confidential
and/or privileged of
Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader of
this communication
is not the intended recipient,unauthorized use,forwarding, printing, storing,
disclosure or copying
is strictly prohibited, and may be unlawful.If you have received this
communication in error,please
immediately notify the sender by return e-mail, and delete the original message
and all copies from
your system. Thank you.
---------------------------------------------------------------------------------------------------
