how to capture count of records from stored procedrure

[attalurisubbu]

Hi, I want only count of a records returning by a particular stored procedure.. Im trying like this..but not coming.. DECLARE @COUNT INT SET @COUNT = EXEC 'SP NAME' SELECT @COUNT please help me.. bala

[Illegal Operation]

SELECT COUNT(*) FROM TABLE WHERE Variable = @Variable. Hope it helps.

Illegal Operation Making Computer Software Talk

[pmarfleet]

@@ROWCOUNT will return the no. of rows affected by the last operation in the current session.

Paul Marfleet

[attalurisubbu]

hi, thanx for ur reply.. but i want count of (number only) records returing by a particular stored procedure..not table records count.. bye

[attalurisubbu]

hi paul, thanx for ur reply.. but in this scenario rowcount will not work.. im trying like this DECLARE @COUNT INT SET @COUNT = EXEC 'SP NAME' SELECT @COUNT can we capture only count of records returning by stored procedures like this??

[pmarfleet]

Works OK when I try it...

Paul Marfleet

[neeraj_indianic]

You can use @@ROWCOUNT in your stored procedure and take the value returned by @@ROWCOUNT as output parameter of stored procedure.