rrr

UPDATE ProductModelInfo SET
ExStone=CASE WHEN Sto_Id IS NULL THEN 0 ELSE 1 END
,DisEnable=CASE WHEN SUBSTRING(B.Number,1,1)='2' THEN 1 ELSE 0 END
FROM ProductModelInfo A
LEFT OUTER JOIN DepartmentInfo B ON B.Dept_Id=A.Fy_Id
WHERE [Pm_Id]=@Pm_Id
posted on   prayforsmile  阅读(160)  评论(0编辑  收藏  举报
努力加载评论中...

点击右上角即可分享
微信分享提示