what is trigger . hw will it use them
- 2 Answers
- 5606 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / m.ramarathna
Triggers are special kind of stored procedure that get
executed automatically when insert,update,delete operation
takes place on a table. Trigger can't be invoked on demand.
when delete,update,insert one data in the table ,that data
will stored in another one table.Nobody can't open the table
.That can open only by the select user.because of trigger
we give full importants to all data .
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / sanjay kumar dinda
Trigger is a procedure which is invoked automatically when
any DML operation occured on a table.
At the time of DML operation , inside trigger SQL provide
the dummy table ( inderted , deleted) , which stores the
errected rows....
| Is This Answer Correct ? | 2 Yes | 0 No |
How to create a new login name in ms sql server?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What are the various editions of sql server 2017 that are available in the market?
Explain the concept of view and Types of views in SQL server?
How to write a query with an inner join in ms sql server?
What are a scheduled jobs?
What are the pre-defined functions in the sql server?
How to list all stored procedures in the current database using ms sql server?
What is the use of stored procedure?
Explain about builtinadministrator?
What is difference between global temporary tables and local temporary tables?
What is a transactions?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
