// This function generates OFFSET, FETCH clause from Top and Skip information. // Note that this should be used only when Skip is present. For only Top, TopClause.WriteSql() // private static void WriteOffsetFetch(SqlWriter writer, TopClause top, SkipClause skip, SqlGenerator sqlGenerator) { DebugCheck.NotNull(skip); skip.WriteSql(writer, sqlGenerator); if (top != null) { writer.Write("FETCH NEXT "); top.TopCount.WriteSql(writer, sqlGenerator); writer.Write(" ROWS ONLY"); writer.Write(" "); } }