批量update

参见http://lj.soft.blog.163.com/blog/static/7940248120109215191358/

例子:update CarSeriesDetail set clicks= case when id=1 then 1 when id=2 then 2 else clicks end

 

posted @ 2016-06-28 15:29  NewObject_1  阅读(138)  评论(0编辑  收藏  举报