Answer / arunkumar2visit

create trigger trigger_name
on tablename
for update
as
if update(col_name)
begin
raiseerror('cannot update column name',16,1)
rollback trac
end

Answer / prasad237

create trigger trigger_name1
on emp
for update
as
begin
if update(ename)
begin
begin tran
raiserror('cannot update column name',16,1)
rollback tran
end
else
print 'table updated'

end

Mention the different types of triggers?

0 Answers  

---

What is sql injection? How to protect against sql injection attack?

0 Answers  

---

How do you drop an index?

0 Answers  

---

What triggers long term care?

0 Answers  

---

Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,

---

List the types of recovery model available in sql server?

0 Answers  

---

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

---

What are the advantages of partitioning?

0 Answers  

---

What is indexed view? How to create it?

0 Answers  

---

What are the disadvantages of using querystrings to send data from one page to another?

0 Answers  

---

What is difference between aggregate and analytic function?

0 Answers  

---

How to modify an existing stored procedure in ms sql server?

0 Answers  

---