11 2016 档案

SQL 删除百万级的数据
摘要：declare @onecount intset @onecount=10000while 1=1begin delete top(@onecount) from ysh where date<'2016-06-21'; IF (@@rowcount<@onecount) BREAK; print 阅读全文
posted @ 2016-11-28 15:39 管学文 阅读(475) 评论(0) 推荐(0)
SQL 自行构造数据源
摘要：INSERT INTO dbo.MenuPermissions ( intFunPageCode , intFatherCode , nvcName, StationID , BelongedTo )SELECT intFunPageCode,intFatherCode,nvcName,Statio 阅读全文
posted @ 2016-11-03 21:59 管学文 阅读(290) 评论(0) 推荐(0)