Answer / kinthada cnu

hi all

Trigger nothing but special kind of stored procedure
it's providing security to table data.And it is automatically
fire when the queary excuted.

ex:
create trigger <trigger name>
on <table name>
for <insert/update/delete>
as
begin
<statments>
end

What is merge join?

0 Answers  

---

What are the basic features of a trigger in ms sql server?

0 Answers  

---

What is blocking?

0 Answers  

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

---

Explain about integration services of Microsoft SQL server?

0 Answers  

---

How to find index size for each index on table?

0 Answers  

---

What is a join and their types?

2 Answers   Challenger Financial,

---

how insert selected column only ?

3 Answers   Robert Half,

---

Difference between report and query parameter. Why do we need different type of parameter?

0 Answers  

---

explain query execution plan

1 Answers  

---

What is a trigger?

4 Answers  

---

How to use old values to define new values in update statements in ms sql server?

0 Answers  

---