sql server - UPDATE if column is not null, if null then leave at null ...

sql server - UPDATE if column is not null, if null then leave at null ...

瀏覽:633
日期:2024-05-23
update tableA set first_name = case when first_name is null then null else 'aaa' end, last_name = case when last_name is null then null else ......看更多