在SQL Server中以块的形式获取结果集

Let's say I have a query that return 10000 rows. Is it possible to configure this query in SQL Server so that it returns the result in chunks with 1000 rows each? So my application receives 1000 rows, processes them, and while it does that SQL Server is working to send the next 1000 rows etc.?Let's say I have a query that return 10000 rows