Insert Trigger || MS SQL SERVER BANGLA TUTORIAL SERIES || PART-15

#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 :    • Paste Special এর কাজ || Microsoft Exc...  
Paste Special :    • Paste Special এর কাজ || Microsoft Exc...  
Sql Table :    • TABLE : CREATE, ALTER, DROP || MS SQL...  
PowerBI :    • PowerBI শিখুন খুব সহজে, আর বদলে ফেলুন...  
Database :    • DATABASE : CREATE, ALTER, DROP  || MS...  
Tips & Tricks :    • Excel Tips & Tricks-01 || Microsoft E...  
Absolute :    • Absolute এর ব্যবহার || Microsoft Exce...  
SUM :    • SUM Function এর ব্যবহার || Microsoft ...  
COUNT :    • COUNT Function এর ব্যবহার || Microsof...  
FLOOR :    • এক্সেলে কিভাবে FLOOR,CEILING,ROUND,RO...  
IF :    • IF ফাংশন এর ব্যবহার শিখুন খুব সহজে ||  
PIVOT :    • Pivot Table || Microsoft Excel Bangla...  
VLOOKUP :    • VLOOKUP এর ব্যবহার || Microsoft Excel...  
Comparison :    • POWER BI || Comparison || Bangla Tuto...