欢迎投稿

今日深度:

sqlserver一次性修改多条,sqlserver修改列名

sqlserver一次性修改多条,sqlserver修改列名


修改客户表?编号为?0101007002,0101007003的楼栋号??007-1-102,007-1-201


UPDATE gas_customer
SET building= CASE
WHEN govid=380 and customer_no='0101007002' THEN '007-1-102'
WHEN govid=380 and customer_no='0101007003' THEN '007-1-201'
END
WHERE
govid=380 and customer_no IN (
'0101007002',
'0101007003'
)

?

www.htsjk.Com true http://www.htsjk.com/Sql_Server/37721.html NewsArticle sqlserver一次性修改多条,sqlserver修改列名 修改客户表编号为0101007002,0101007003的楼栋号007-1-102,007-1-201 UPDATE gas_customer SET building= CASE WHEN govid=380 and customer_no='0101007002' THEN '007-1-102' WHEN...
相关文章
    暂无相关文章
评论暂时关闭