rowcount setting
Causes Adaptive Server to stop processing a query after a specified number of rows are affected
Rowcount is:
Session-specific
Activated by: set rowcount N
Turned off by: set rowcount 0
Rowcount is a key parameter used in several methods of finding the top N values
-- Example: show top 10 salaries
set rowcount 10
go
select emp_name, salary from employee order by salary desc
go
set rowcount 0
go
|
|
