09 2015 档案

encodeURIComponent()对js参数进行编码，防止错误值
摘要：encodeURIComponent()对js参数进行编码，防止错误值 阅读全文
posted @ 2015-09-14 18:31 范海辛1990 阅读(340) 评论(0) 推荐(0)
相同的sql 分页查询结果
摘要：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 阅读(157) 评论(0) 推荐(0)
sql 返回插入新纪录的id
摘要：StringBuilder strSQL = new StringBuilder();23 strSQL.Append("insert tb_SelCustomer(Name) ");24 strSQL.Append("OUTPUT ... 阅读全文
posted @ 2015-09-07 14:56 范海辛1990 阅读(257) 评论(0) 推荐(0)
复制表结构sql
摘要：select * into RRR_Goods20150907 from RRR_Goods where 1=2 阅读全文
posted @ 2015-09-07 11:17 范海辛1990 阅读(146) 评论(0) 推荐(0)