What is trigger ?
Answers were Sorted based on User's Feedback
Answer / ramesh tankala
Trigeer is like stored procedure which executes
automatically .
Trigger is User defined data integrity
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / piyush
Triggers are those procedures written in PL/SQL that fire whenever one of the following operation occur, DML statements on a particular schema object, DDL statements issued within a schema or database, user log on or log off events, server errors, database startup, or instance shutdown.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / indu bala
trigger is any event which is raised automatically by
database server after any instruction like
update,delete,insert is performed
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / kalyana chakravarthy maddipati
A trigger is a stored procedure fires implicitly when ever a DML(Insert, update & Delete) occurs. It is stored at server side. Its compiled and no need to compile and execute always.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramya
Trigger is a server-side progrm used for events(user
actions-click,key press etc..)
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / abdulla
Trigger is Limited form stored procedure associated with tables.
Is This Answer Correct ? | 0 Yes | 2 No |
how do u find least salary in a table
Explain few of the new features of sql server 2008 management studio
What are out-of-range errors with date and time literals?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What are subqueries in sql server? Explain its properties.
What functions can a view be used to performed?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
Explain what are the basic functions for master, msdb, model, tempdb databases?
Explain different types of collation sensitivity?
How to implement service broker?
What is a heap?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?