Technical Article

Select from x th row next y rows

This code will show rows from 17th and then next 3 ordered by name from table authors in database pubs. Table must have primary key and of course ordered column. You can change value 'from' in line 'SET ROWCOUNT 17' and value 'next' (how many rows)in line SELECT TOP 3. It is good to show […]

You rated this post out of 5. Change rating

2004-10-21 (first published: )

206 reads

Blogs

Advice I Like: Responsibility

By

“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...

Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports

By

Originally published April 2022; substantially updated July 2026. This post is a complete replacement...

Getting Started with Azure SQL Developer on Macbook

By

The idea behind Azure SQL Developer is for anyone to build, iterate, and test...

Read the latest Blogs

Forums

ALAMAT KANTOR BCA KCP Arundina Cibubur Telp:083831618008

By Layanan BCA 24 JAM

WhatsApp:0838-3161-8008 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26 Blok A/24, RT.2/RW.11, Cibubur,...

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

By abdalah.mehdoini

Hello everyone , I am planning to migrate a database from SQL Server 2014...

SQL Agent Job Automated Change Capture Process

By James Greaves

Comments posted to this topic are about the item SQL Agent Job Automated Change...

Visit the forum

Question of the Day

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

See possible answers