Interested to Buy Any Domain ? << Click Here >> for more details...
what is trigger . hw will it use them
- 2 Answers
- 6246 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 |
Determine when an index is appropriate?
Explain stored procedure?
what is the basic diffrence betn a col declared in char(1) and in varchar(1)
Why do we use stored procedures in sql server?
What xml support does the sql server extend?
What the difference between UNION and UNIONALL?
What is indexing and its types?
Is it possible to have clustered index on separate drive from original table location?
How to write a query with an inner join in ms sql server?
Explain transaction server consistency?
Explain Geometry datatype in sql server 2008 with example
Can we have more than one NULL in a column having unique constraint?
-
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)
