日期:2014-05-18 浏览次数:20532 次
UPDATE [test].[dbo].[Student] SET [Name] = case when classid = 111 then '英雄' else name end, weight=555 WHERE sid='S0004'
------解决方案--------------------
UPDATE [test].[dbo].[Student]
SET [Name] = case when classid = 111 then '英雄' else name end,
weight=555
WHERE sid='S0004'
------解决方案--------------------
UPDATE [test].[dbo].[Student] SET name = case when classid = 111 then '英雄' else name end, weight=555 WHERE sid='S0004'