Subject | converting MSSQL stored procedure to Firebird |
---|---|
Author | tsangccn <tsang_cn@ctimail3.com> |
Post date | 2003-01-27T10:49Z |
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 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