摘要: select * from (select ROW_NUMBER() over(order by id desc) as rowsid,name from _Customer)as T where rowsid between 1 and 10;with datalist as(select ROW... 阅读全文
posted @ 2015-09-07 16:57 范海辛1990 阅读(148) 评论(0) 推荐(0) 编辑
摘要: StringBuilder strSQL = new StringBuilder();23 strSQL.Append("insert tb_SelCustomer(Name) ");24 strSQL.Append("OUTPUT ... 阅读全文
posted @ 2015-09-07 14:56 范海辛1990 阅读(235) 评论(0) 推荐(0) 编辑
摘要: select * into RRR_Goods20150907 from RRR_Goods where 1=2 阅读全文
posted @ 2015-09-07 11:17 范海辛1990 阅读(134) 评论(0) 推荐(0) 编辑