Interested to Buy Any Domain ? << Click Here >> for more details...
What is a trigger?
- 4 Answers
- 8262 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Triggers are basically used to implement business rules.
Triggers is also similar to stored procedures. The
difference is that it can be activated when data is added or
edited or deleted from a table in a database.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / hari
Trigger is a special kind of storedprocedure automatically
executed when DML Operations done.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kumar
In simpler words, triggers act BEHIND-THE-SCENE once they
are created.They are extremely powerful feature of SQL
Server but not exploited fully to the extent they could be..
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / mukesh kumar srivastava
A trigger is a special kind of stored procedure that responds to specific events. There are two kinds of
triggers: Data Definition Language (DDL) Triggers and Data Manipulation Language (DML) Triggers.
| Is This Answer Correct ? | 1 Yes | 0 No |
please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.
How can you append an identity column to a temporary table?
What are the recovery models for a database?
What is the use of sql profiler in sql server 2012?
1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?
What is default constraint in ms sql server?
What is instead of dml trigger?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is the difference between left and right outer join?
What are the different types of triggers in SQL SERVER?
-
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)
