What is Trigger,Store procedure, join in sql query and their syntax

Question

Accepted Answer

A trigger is a database object that is automatically executed in response to certain events. A stored procedure is a named group of SQL statements that can be executed. A join is used to combine rows from two or more tables based on a related column between them.

Triggers are used to enforce business rules, perform data validation, or automate tasks.
Stored procedures are used to encapsulate a set of SQL statements for reuse and better performance.
Joins are used to retrieve data from multiple tables based on a related column.
Syntax examples: TRIGGER trigger_name {BEFORE | AFTER} {INSERT | UPDATE | DELETE} ON table_name FOR EACH ROW BEGIN ... END;
Syntax examples: CREATE PROCEDURE procedure_name [parameters] AS BEGIN ... END;
Syntax examples: SELECT column_name(s) FROM table1 JOIN table2 ON table1.column_name = table2.column_name;

Accepted Answer

trigger is a stored procedure that runs automatically when various events happen

Accepted Answer

Stored procedures can be invoked explicitly by the user

On the other hand, trigger is a stored procedure that runs automatically when various events happen

As update, insert, delete)

What is Trigger,Store procedure, join in sql query and their syntax

Top Manabh Software Solutions DOT NET Developer interview questions & answers

Popular interview questions of DOT NET Developer

Top HR questions asked in Manabh Software Solutions DOT NET Developer