A stored procedure ia s named collection of SQL statements and procedural logic that is compiled, verified and stored in a server database. It is typically treated like any other database object. Stored
Latest Answer : A stored procedure is a precompiled collection of Transact-SQL statements and optional flow control statements, similar to an executable script. Stored procedures are stored and run within the database. You can run a stored procedure with the EXECUTE ...
Triggers are special user defined actions usually in the form of stored procedures, that are automatically invoked by the server based on data related events. It can perform complex actions and can use
The triggers are called implicitly by database generated events, while stored procedures are called explicitly by client applications.
Latest Answer : Triggers Are Genrated when Some Invalid Data Filled In The Form, And Rules Are Deployed To The Particular Field It Allows Only Valid Entry. ...