Answer Posted / 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

Tell me what are the essential components of sql server service broker?

518

---

How can you hide the sql server instances?

528

---

Explain view in sql server?

636

---

What is nonclustered index on computed columns?

579

---

What are the instances when triggers are appropriate?

531

---

---

Can you move the resources after pausing the node? : sql server database administration

604

---

Explain about builtinadministrator?

612

---

How to check parameter value in stored procedure sql server?

479

---

Do you know how to send email from database?

557

---

What are the advantages of sql azure?

116

---

What is a transact-sql statement batch in ms sql server?

513

---

What are different types of collation sensitivity?

544

---

Explain the collation?

642

---

What is the most common type of join?

537

---

What is query parameter in ssrs?

120

---