RE: What is stored procedure. How do you create stored procedure
A stored procedure is a group of SQL statements that form a logical unit and perform a particular task. Stored procedures are used to encapsulate a set of operations or queries to execute on a database server. For example, operations on an employee database (hire, fire, promote, lookup) could be coded as stored procedures executed by application code. Stored procedures can be compiled and executed with different parameters and results, and they may have any combination of input, output, and input/output parameters.
RE: What is stored procedure. How do you create stored procedure
A precompiled collection of SQL statements stored under a name and processed as a unit. Stored procedures can: 1.Accept input parameters and return multiple values in the form of output parameters to the calling procedure or batch. 2.Contain programming statements that perform operations in the database, including calling other procedures. 3.Return a status value to a calling procedure or batch to indicate success or failure (and the reason for failure).
RE: What is stored procedure. How do you create stored procedure
A stored procedure is a set of procedural sql querry which when executed under sql environment will perform those operations which are specified in those sql querry form
RE: What is stored procedure. How do you create stored procedure
stored procedure is nothing but a colletion of sql statements with conditional structures to perform one or more tasks combinedly.which is compiled and can call other stored procedures..
What is stored procedure. How do you create stored procedure
A stored procedure or function is an object stored in the database, and run as a unit to solve a specific problem or perform a set of related tasks. Procedures and functions permit the caller to provide parameters that can be input only, output only, or input and output values. A procedure is explicitly run by a user, application, or trigger.
Procedures and functions are identical except that functions always return a single value to the caller, while procedures do not.
RE: What is stored procedure. How do you create stored...
Stored Procedure is an object design with business logic and stored in the database .Since it stays in the database ,the execution of the business logic is more faster...
