اشکال در تبدیل کد Sql

[farshid_82]

سلام
دوستان چطوری میشه کد زیر و برای interbase یا firebird نوشت.

CREATE PROCEDURE test
AS
BEGIN
declare @id int, @price int,@price1 int, @sum int
set @sum = 0
DECLARE sum_cursor Cursor
FOR SELECT id, Pay,Cash FROM T1 ORDER BY SDate
OPEN sum_cursor
FETCH NEXT FROM sum_cursor
INTO @id, @price,@price1
WHILE @@FETCH_STATUS= 0
BEGIN
select @sum = @sum + (@Price-@Price1)
update T1 set RE = @sum where Id = @Id
FETCH NEXT FROM sum_cursor
INTO @id, @price,@price1
END
CLOSE sum_cursor
DEALLOCATE sum_cursor
select*from T1 ORDER BY SDAte
END
GO