What is a good practice for a developer to follow when writing a - ProProfs Discuss
Advertisement

What is a good practice for a developer to follow when writing a trigger?

What is a good practice for a developer to follow when writing a trigger?

Change Image    Delete



Asked by Catherine halcombe, Last updated: Nov 12, 2024

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

f.Brian

f.Brian

f.Brian
F.Brian

Answered Jan 29, 2018

If a data structure developer is writing a trigger then it is a good practice for them to use the Map data structure to hold query results by ID and use the Set data structure to ensure distinct records. A trigger is an SQL (structured Query Language) procedure that initiates an action when an event occurs.

A trigger is something that cannot be called or executed but instead automatically fires as a result of a data modification. SQL is the primary language that is used to communicate with a database. It is officially the standard language for relational database management systems.

upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Oct 26, 2016

Using the Map data structure to hold query results by ID
2. Using the Set data structure to ensure distinct records
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.