_小马哥

摘要： DECLARE @pagesize INT= 10; --每页10条 DECLARE @page INT = 1; --第几页 SET STATISTICS TIME ON; SELECT * FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY id ASC ) AS rownumber , * ... 阅读全文

摘要： DECLARE cursor_name CURSOR FOR --定义游标 SELECT REPLACE(JSURL,'&FP=1&FP=1','&FP=1'),JSImgID FROM [srv_lnk_wps].wps_jt_2017.dbo.T_JSURL0331 WHERE JSImgID IS NOT NULL AND JSURL IS NOT NULL GROUP BY JSImg... 阅读全文