Updated Trigger || MS SQL SERVER BANGLA TUTORIAL SERIES || PART-16
#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 Excel Ba...
Paste Special : • Paste Special এর কাজ || Microsoft Excel Ba...
Sql Table : • TABLE : CREATE, ALTER, DROP || MS SQL SERV...
PowerBI : • PowerBI শিখুন খুব সহজে, আর বদলে ফেলুন নিজে...
Database : • DATABASE : CREATE, ALTER, DROP || MS SQL ...
Tips & Tricks : • Excel Tips & Tricks-01 || Microsoft Excel ...
Absolute : • Absolute এর ব্যবহার || Microsoft Excel Ban...
SUM : • SUM Function এর ব্যবহার || Microsoft Excel...
COUNT : • COUNT Function এর ব্যবহার || Microsoft Exc...
FLOOR : • এক্সেলে কিভাবে FLOOR,CEILING,ROUND,ROUNDUP...
IF : • IF ফাংশন এর ব্যবহার শিখুন খুব সহজে ||
PIVOT : • Pivot Table || Microsoft Excel Bangla Tuto...
VLOOKUP : • VLOOKUP এর ব্যবহার || Microsoft Excel Bang...
Comparison : • POWER BI || Comparison || Bangla Tutorial