Set Output parameter to rowcount

Question

I have the following procedure

create procedure hozzaszolas
  @pHozzaszolasSzam int
  , @pmcsz int output
as
begin
  update Cikkek
    set Ertekeles = Ertekeles + 1
  where Cikkek.CikkCim in (
    select Cikkek.CikkCim
    from Cikkek
    left join Hozzaszolasok on Cikkek.CikkID = Hozzaszolasok.CikkID
    where Cikkek.Ertekeles < 10
    group by Cikkek.CikkID, Cikkek.CikkCim
    having count(Hozzaszolasok.CikkID) >= @pHozzaszolasSzam
  )
end

I would like to get the number of rows affected in the output param, but I don't know how.

Did you google that before asking? https://stackoverflow.com/questions/1589466/execute-stored-procedure-with-an-output-parameter — Dale K, Feb 28 '19 at 23:37
Possible duplicate of [Execute stored procedure with an Output parameter?](https://stackoverflow.com/questions/1589466/execute-stored-procedure-with-an-output-parameter) — RN92, Mar 01 '19 at 01:09

score 0 · Answer 1 · answered Mar 01 '19 at 03:31

@@ROWCOUNT returns the number of records affected by the last statement.

create procedure hozzaszolas
  @pHozzaszolasSzam int
  , @pmcsz int output
as
begin
  update Cikkek
    set Ertekeles = Ertekeles + 1
  where Cikkek.CikkCim in (
    select Cikkek.CikkCim
    from Cikkek
    left join Hozzaszolasok on Cikkek.CikkID = Hozzaszolasok.CikkID
    where Cikkek.Ertekeles < 10
    group by Cikkek.CikkID, Cikkek.CikkCim
    having count(Hozzaszolasok.CikkID) >= @pHozzaszolasSzam
  )
set @pmcsz= @@ROWCOUNT
end

Set Output parameter to rowcount

1 Answers1