Scribd
Upload
2 views1 page

SQL Procedures, Triggers, and Functions Guide

The document outlines various database concepts including stored procedures, triggers, views, common table expressions (CTEs), and indexing. It discusses the advantages and disadvantages of triggers, the differences between stored procedures and functions, and the ACID properties of transactions. Additionally, it provides a request to create a stored procedure for retrieving total salary for a department.

Uploaded by

monkeydkamal066
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views1 page

SQL Procedures, Triggers, and Functions Guide

The document outlines various database concepts including stored procedures, triggers, views, common table expressions (CTEs), and indexing. It discusses the advantages and disadvantages of triggers, the differences between stored procedures and functions, and the ACID properties of transactions. Additionally, it provides a request to create a stored procedure for retrieving total salary for a department.

Uploaded by

monkeydkamal066
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

[Link] is stored procedure and its advantages?

[Link] is trigger advantages and disadvantages?

3.d/w between view and cte?

[Link] about lead and lag?

[Link] to set index and drop the index?

[Link] about functions?

7.d/w between stored procedure and functions?

[Link] is acid properties?

[Link] about TCL

[Link] is DCL

12. CREATE A STORED PROCEDURE TO RETERIVE TOTAL SALARY FOR DEPARTMENT

You might also like