Tell me about Triggers?
Answers were Sorted based on User's Feedback
Answer / pradeep
Triggers in DB are analogus to the triggers in hand
grenades.
It are reffered a stored procedure call that initiates its
action on any event occures such as insert, update or
delete query.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / shalini
trigger is a block of code that constitutes a set of T-sql
statements activated to response in certain action.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / praveen ch
trigger is nothing but a logic, this logic like a stored
procedure and which is uesd to represented as before
updation of table or after updation of the table
thank u
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the purposes and advantages stored procedure?
Tell me what is normalization? Explain different forms of normalization?
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?
What Are Three Rules to UseĀ UNION IN SQL SERVER
What are commit and rollback in sql?
What is a job?
How to specify the collation for a character data type in ms sql server?
Write a SQL query to delete a table?
What is a primary index?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
When to use Inner join & when to use subquery?
How many partitions a clustered index has by default in sql server 2012?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)