if exists (select name from sys.procedures where name = 'CheckOrders')
drop procedure CheckOrders
go
create procedure CheckOrders
@Drzava nvarchar (15)
with encryption as
declare @OrderID int
declare crsOrders cursor keyset for
select OrderID
from Orders
where Orders.ShipCountry = @Drzava
open crsOrders
fetch next from crsOrders
into @OrderID
while @@fetch_status = 0
begin
update Orders
set Orders.RequiredDate = Orders.OrderDate
where Orders.RequiredDate < Orders.OrderDate
and Orders.OrderID = @OrderID
fetch next from crsOrders
into @OrderID
end
close crsOrders
deallocate crsOrders
/*
execute CheckOrders 'France'
*/
i to sve radi, ali bi sad jos zelio dodati izlazni parametar @KolikoFetcheva koji bi davao rezultat koliko je kursor procitao redova. Kako da to izvedem?