Helpline: 1-866-554-2512
SQL database recovery software to recover lost data, tables, views,
stored procedures, rules, defaults, user defined data types and
triggers
from Microsoft SQL server database
|
| Home >> Stored Procedure, View & Trigger |
| Stored Procedure, View & Trigger |
| What is Stored Procedure? In DBMS, Stored Procedure is a set of SQL (Structured Query Language) statements stored in the database dictionary that improves the efficiency, usability and security of the database client server applications. This is a database query stored in a compiled form with an assigned name. What is View? In DBMS, view is a logical or virtual table that is used for portraying information in the database. Unlike normal tables, a view is not a part of physical schema of the relational database; it’s a virtual, dynamic table computed or collated from the data in the database. View can be implemented by arranging data items in a special order by highlighting some items, or by displaying certain items. You can specify a number of views. The best view for any particular purpose depends upon the information that the user needs. Changing the value of the data in any table alters the data shown in the view. The result value of view is stored in a permanent table whereas the result of the query is shown in a temporary table. What is Trigger? A trigger in the database is a procedure code that is executed automatically in return to some operations or events on a particular database table. Triggers can restrict access to special data, audit data modifications and perform logging. Triggers give a tremendous degree of flexibility to the database administrators and developers. The triggers can be divided into two classes called “Statement Triggers” and “Row Triggers”.   |
