2012年2月28日
SQL批量执行存储过程
摘要： --批量执行存储过程SELECT ROW_NUMBER() over(ORDER BY bo.orderno) RowNumber, bo.OrderNo,bo.OrderStatus INTO #aaaFROM bdOrder boJOIN mdDepartment md ON bo.DepartmentID=md.IDJOIN mdDepartment MD2 ON md.OrganID LIKE MD2.OrganID+'%'AND md2.ID=16AND bo.OrderDate>'2012-02-28'AND bo.OrderStatus IN 阅读全文
posted @ 2012-02-28 18:31 iewysdcwy 阅读(1316) 评论(0) 推荐(0) 编辑