IndexingStored procedureCrystal reports ViewsTriggers

Question

Hi everybody can some one please tell me what are the following thing. Why do they use.

Stored procedure
Crystal reports
Views
Triggers

Please give me the example of these things. How can i create it???.............
Thanks in advance.

Muralidharan Deenathayalan · Answer

Stored Procedures : A stored procedure is a subroutine available to applications accessing a relational database system. Stored procedures (sometimes called a proc sproc StoPro StoredProc or SP) are actually stored in the database data dictionary. http://msdn.microsoft.com/en-us/library/aa174792(v=sql.80).aspx Crystal Reports : Crystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources . Several other applications including Microsoft Visual Studio  at one time bundled an OEM version of Crystal Reports as a general purpose reporting tool. [ 1 ] Crystal Reports is a popular report writer  especially so when Microsoft bundled it with Visual Studio versions 2003 through 2008. Microsoft discontinued this practice and later released their own competitive reporting tool SQL Server Reporting Services (SSRS). [ 2 ] [ verification needed ] Crystal Reports for Visual Studio 2010 is still available as add-on software. http://msdn.microsoft.com/en-us/library/ms225593(v=vs.80).aspx Triggers: A trigger is a special kind of stored procedure that is invoked whenever an attempt is made to modify the data in the table it protects. Modifications to the table are made ussing INSERTUPDATEOR DELETE statements.Triggers are used to enforce data integrity and business rules such as automatically updating summary data. It allows to perform cascading delete or update operations. If constraints exist on the trigger tablethey are checked prior to the trigger execution. If constraints are violated statement will not be executed and trigger will not run.Triggers are associated with tables and they are automatic . Triggers are automatically invoked by SQL SERVER. Triggers prevent incorrect  unauthorizedor inconsistent changes to data. http://www.go4expert.com/forums/showthread.php?t=15510 Views : A view is in essence a virtual table. It does not physically exist. Rather it is created by a query joining one or more tables. The syntax for creating a VIEW is: CREATE VIEW view_name AS SELECT columns FROM table WHERE predicates; Hope this helps you.

Indexing,Stored procedure,Crystal reports Views,Triggers