In message <b132qs+gtu3@...>, tsangccn <tsang_cn@...>
<tsang_cn@...> writes

>Hello,
>
>I am converting stored procedure from MSSQL to Firebird,
>How to define the stored procedure in Firebird for
>a stored procedure in MSSQL as
>
>CREATE PROCEDURE insertRecord
> @name varchar(10),
> @id int output
>AS
> INSERT INTO myTable (name) values(@name)
> SELECT @id == @@IDENTITY
>GO
>
>Please Help.
>
>Thanks
>CN

I think that you are trying to make id as an auto incrementing number.
If this is correct, then you can make the field itself auto increment,
with something like
ID int(11) NOT NULL auto_increment

--
Pete Clark