摘要:
DECLARE Sub_CURSOU_MS CURSOR FOR SELECT FInkqty, FPrjsht, FMatno FROM #subworktimeink OPEN Sub_CURSOU_MS; FETCH NEXT FROM Sub_CURSOU_MS INTO @finkqty, 阅读全文
摘要:
按指定字段排序、分页 --取第5页的30条数据 DECLARE @Page INT = 5 DECLARE @PageSize INT = 30 SELECT ep_survivalstatus, ep_CardNo FROM dbo.ep_CardBase ORDER BY CASE WHEN e 阅读全文