Examples of using Stored procedure in English and their translations into Russian
{-}
-
Official
-
Colloquial
IBProvider automatically determines a way of stored procedure execution and generates a list of parameters.
Stored procedure of the second type(with result in output parameters)
In the following example, we will create a simple stored procedure SP_ADD(if it was not created earlier) and execute it.
In the following example, in the separate thread performed query of calling a stored procedure, and the main thread cancels this request.
If stored procedure return result set, OUT-parameters will be in PROCEDURE_COLUMNS schema, else if SP return OUT-parameters then its info will be in PROCEDURE_PARAMETERS.
For example, to run the stored procedure that displays the overall space usage of the database, enter sp_spaceused.
It let us convert almost all the stored procedure code over to PL/SQL automatically, leaving only a small percentage for us to handle manually.
You can create and run a stored procedure that deletes a user key identified by its security identifier(SID)
NPS formats accounting data as an XML document that it sends to the report_event stored procedure in the SQL Server database that you designate in NPS.
It the following Firebird c example new generator value returned through the stored procedure.
By default, null or value which is specified in the stored procedure on the server will be used.
The SQL Server 2005 DBCC CHECKDB(Database Consistency Check) stored procedure can be used to check the logical and physical integrity of all the objects in the site database.
The SQL Server 2005 DBCC CHECKDB stored procedure can be used to check the logical and physical integrity of all the objects in the site database.
When you run the stored procedure, it calculates the number of“Site System is possibly down” alerts that are raised during the specified number of days, subtracts the downtime
Using the sp_OACreate stored procedure, any OLE automation object that implemented regular expressions could be used, but you had to create a COM object first,
Default value automatic mode. If stored procedure return result set, OUT-parameters will be in PROCEDURE_COLUMNS schema, else if SP
Visual Query Builder and Stored Procedure Debugger for InterBase and Firebird SQL scripts development
Visual Query Builder and Stored Procedure Debugger for InterBase and Firebird SQL scripts development
Possibility of converting stored procedures from syntax PL/SQL.
We will show in details how to debug the PL/pgSQL stored procedures interactively.