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

what are triggers? : Sql server database administration

899

---

How to use copy and concatenate commands in SQL?

1129

---

Why normalization is used?

1001

---

What are SSL and TSL protocols?

973

---

Explain SSRS Architecture?

195

---

What Are the Main Features of SQL Azure?

117

---

What is etl - extraction, transformation, and loading?

912

---

Tell me what is the significance of null value and why should we avoid permitting null values?

973

---

Why we should not use triggers?

959

---

Is sql server 2016 free?

926

---

What is normalization and its types?

1017

---

What is the primary use of the model database?

1076

---

What are the different types of replication are there in sql server 2000?

1030

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2094

---

What is a result set object returned by odbc_exec()?

1014

---