Hi Guest

HomePage

1 1

To improves our performance please Like Share Subscribe(Will boost us)

Difference in between Triggers and Event Notifications?
Question Posted on 12 Apr 2023

Home >> DataBase >> sql questions >> Difference in between Triggers and Event Notifications?

Difference in between Triggers and Event Notifications?
Below are the 4 main difference in between Triggers and Event Notifications:-
0
0

NumberBase of differenceTriggersEvent Notifications
1CodesIn triggers we can run T-SQL or CLR codes.In Event notification we can not run any codes.
2Processes ServerTriggers must be processed on local servers.When we say about the Event Notification it can be processed on remote servers.
3ScopeTriggers are processed synchronously within the scope of transactionsThey are processed asynchronously, not within the scope of transactions
4EventsWhen we say about the respond in Triggers it will respond to both DML and DLL events. Event notification respond to DDL evenets and a subset of SQL trace events.


Most Visited Questions:-

Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a More...

Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra More...

Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres More...

What is Gulpjs and some multiple choice questions on Gulp
Gulpjs is an open source whihc helps in building Javascript More...

Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec More...




Other Important Questions
Define N in nvarchar and in nchar?
difference between drop and truncate command
difference between procedure and function
different types of databases in sql
Difference Between Update Lock and Exclusive Lock






Most Visited Questions
Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |
     
 
Privacy policy | Terms and Conditions | Blog


If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)
 

1
Home About Us GroupChat
 
Sitemap Feedback Contact us