Examples of using Stored procedure in English and their translations into Russian
{-}
- 
                                                                                        Official
                                                                                    
 - 
                                                                                        Colloquial
                                                                                    
 
Sample7 Stored procedure.
Work with IN and OUT parameters in stored procedure.
Calling a stored procedure.
Stored procedure call command«exec SP» was improved.
Sample2 Work with IN and OUT parameters in stored procedure.
The Stored procedure returns a result set.
Let's check our assumption and change the stored procedure a bit.
We call this stored procedure via Linked Server.
The only alternative was to create an extended stored procedure.
Executing a stored procedure that returns a set.
Let's make a trivial MATH package with a single stored procedure- SP_ADD.
Stored procedure can return the result in two ways.
For execution of first type stored procedure need to use«select… from…» statement.
For Stored procedure queries and select queries RowsAffected parameter will be set to -1.
The result will be identical- the stored procedure returns«result» equal to three.
You can specify a single SQL command up to 255 characters long orthe name of an existing stored procedure.
Executing a stored procedure that returns OUT parameters.
Bug fixed Incorrect command behavior when forming stored procedure OUT- parameters.
It analyze stored procedure BLR or stored procedure source code.
The create command is used to establish a new database, table,index, or stored procedure.
And let's write code to call the stored procedure by request«exec math. sp_add».
Stored procedure of the second type(with result in output parameters) is executed by using SQL-query of the form.
The unit of transaction is the stored procedure, which is Java interspersed with SQL.
Microsoft SQL DB converter tool is capable of converting table definition,converting views and stored procedure.
Limitations removed for stored procedure call in a connection with the first dialect.
The only difference is to implement the procedure  of deriving the indexing key as a stored procedure in an existing DBMS.
The other way is to call the stored procedure using an execute procedure  instruction.
There is a stored procedure in employee. fdb that returns employee's project IDs.
In the case of a such request,IBProvider automatically determines a way of stored procedure execution and generates a list of parameters.
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, then make at least one IDispatch call, then destroy the object.