yuanws

摘要： --更新数据1.推荐：update #t1 set #t1.c2 = #t2.c2, #t1.c3 = #t2.c3, #t1.c4 = #t2.c4 from #t2 where #t1.c1 = #t2.c1 2.update tags set usednumber=usednumber+(select b.usednumber from tag_tousenumber b where tags.tagname=b.tagname and tags.channelid=b.channelid and datediff(day,b.addeddate,getdate())<1)会导致第 阅读全文