|
another way to find result set size
hi,
this is the another way to find the resultset size.
select * from table_name select @@rowcount no_of_rows
which will give two resultset
first one is the actual data
second one is the no of rows in the first resultset.
eg.
If the select query have three values
Emp_no emp_name
--------------------
1 AA
2 BB
3 CC
the above one is the first result set
no_of_rows
-----------
3
|