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 are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---

How to provide Security for package?

1 Answers   Convergys,

---

How do I list the available tables in a database I'm querying?

4 Answers  

---

What is the difference between the 2 operating modes of database mirroring?

0 Answers  

---

What is cte (common table expression)?

0 Answers  

---

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

---

What is dbcc updateusage?

0 Answers  

---

How can we determine what objects a user-defined function depends upon?

0 Answers  

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

0 Answers   IBM,

---

Define clusters?

0 Answers  

---

How can you insert null values in a column while inserting the data?

0 Answers  

---