Interested to Buy Any Domain ? << Click Here >> for more details...
wat is mean by trigger?.......normally wat use......when
trigger used in sql...........
plz cleary say with example.......
- 2 Answers
- 6190 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vimal p.s
A trigger is a SQL procedure that initiates an action when
an event (INSERT, DELETE or UPDATE) occurs. Triggers are
stored in and managed by the DBMS.Triggers are used to
maintain the referential integrity of data by changing the
data in a systematic fashion. A trigger cannot be called or
executed; the DBMS automatically fires the trigger as a
result of a data modification to the associated table.
Triggers can be viewed as similar to stored procedures in
that both consist of procedural logic that is stored at the
database level. Stored procedures, however, are not event-
drive and are not attached to a specific table as triggers
are. Stored procedures are explicitly executed by invoking
a CALL to the procedure while triggers are implicitly
executed. In addition, triggers can also execute stored
procedures.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Do you know what are acid properties of transaction?
What are the differences between union, intersect, and minus operators?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Who is the owner of a schema in ms sql server?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
How to enable tcp/ip protocol on a sql server?
What are the different kinds of ssrs reports?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Explain the steps needed to create a scheduled job?
What is used to replicate sessions between instances in coldfusion clusters?
Give the query of getting last two records from the table in SQL SERVER?
How to drop existing views from a database in ms sql server?
Explain how to send email from sql database?
What is the most common type of join?
