Hi all!
In Sql Server, I can write stored procedure which return records, with no
output parameters. In firebird, I can do the same?
Ex:
ALTER PROCEDURE [dbo].[st_BALANCE_ASSETSelect] (
@BALANCE_ASSET_KEY uniqueidentifier
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT
[ASSET_DETAIL_KEY],
[DEPARTMENT_KEY],
[BALANCE_ASSET_MONTH],
[BALANCE_ASSET_YEAR],
[BALANCE_ASSET_AMOUNT],
[BALANCE_ASSET_KEY]
FROM
[BALANCE_ASSET]
WHERE
[BALANCE_ASSET_KEY] = @BALANCE_ASSET_KEY
END
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
