In SQL Server is there a way to have an output parameter return the total number of records (for paging) in a parameterized query?
+3
A:
A stored procedure can have an output parameter, but not a standard query. You could execute an initial query to get the record count, or return mutliple results sets from one query.
ck
2009-10-12 16:29:00
A:
No, but You can do something like that:
SELECT
*,
COUNT() OVER(PARTITION BY ID)
FROM TABLE
Not very pretty, but returns record count. You can also use ROW_NUMBER().
LukLed
2009-10-12 19:30:28