摘要:
--更新数据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)会导致第 阅读全文
posted @ 2009-04-20 16:32 yuanws 阅读(394) 评论(0) 推荐(0) 编辑