#banglatutorial #goviral #viral #sqltutorial #sqlserver #sql #sqltutorial #triggers #expert #realtime

Hello Viewers, Welcome to my channel. A trigger is a set of SQL statements that reside in system memory with unique names. It is a specialized category of stored procedure that is called automatically when a database server event occurs. Each trigger is always associated with a table.

A trigger is called a special procedure because it cannot be called directly like a stored procedure. The key distinction between the trigger and procedure is that a trigger is called automatically when a data modification event occurs against a table. A stored procedure, on the other hand, must be invoked directly.

The following are the main characteristics that distinguish triggers from stored procedures:

We cannot manually execute/invoked triggers.
Triggers have no chance of receiving parameters.
A transaction cannot be committed or rolled back inside a trigger.
Watch out my other videos:

Subscribe : https://youtu.be/H4gvD71JnuI
Paste Special : https://youtu.be/H4gvD71JnuI
Sql Table : https://youtu.be/KgIzN6DfyZo
PowerBI : https://youtu.be/9Xz4M7tzd3Y
Database : https://youtu.be/oZvuXezg70M
Tips & Tricks : https://youtu.be/SomlAcRJF6Y
Absolute : https://youtu.be/vbHpN4yY2pw
SUM : https://youtu.be/0Sh7l_z7S8M
COUNT : https://youtu.be/r6dV8kQjgbI
FLOOR : https://youtu.be/FE9mPi3Cmkc
IF : https://youtu.be/YjarpE_wX4Y
PIVOT : https://youtu.be/N44HytdIwmg
VLOOKUP : https://youtu.be/hbpMMs7-Y9Q
Comparison : https://youtu.be/-_tzxNt3oxo