Indexing,Stored procedure,Crystal reports Views,Triggers

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 Studioversions 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 INSERT,UPDATE,OR 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 table,they 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 , unauthorized,or 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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

15y ago
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 Studioversions 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 INSERT,UPDATE,OR 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 table,they 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 , unauthorized,or 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.
0