Answer / rafi.sk

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.
Nested Trigger: A trigger can also contain INSERT, UPDATE
and DELETE logic within itself, so when the trigger is
fired because of data modification it can also cause
another data modification, thereby firing another trigger.
A trigger that contains data modification logic within
itself is called a nested trigger.

Answer / gopi

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.

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

---

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

What will you do If the low Performance occurs?

2 Answers  

---

List out the different types of locks available in sql server?

0 Answers  

---

What are examples of triggers?

0 Answers  

---

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

---

What part does database design plays a role in performance of an sql server-based application?

0 Answers  

---

What are the requirements on sql server network connections?

0 Answers  

---

What is the difference between substr and charindex in the sql server?

0 Answers  

---

Explain the usage of floor function in sql server.

0 Answers  

---