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

How to enable tcp/ip protocol on a sql server?

0 Answers  

---

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

---

where do you use Isolations?give me some exmpale?

1 Answers  

---

what is normalization? what is denormalization?

9 Answers   Satyam,

---

What is subquery? Explain the properties of a subquery?

0 Answers  

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

What is a function? Give some example?

3 Answers  

---

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

does physical index sort data

1 Answers  

---

What is rolap and its advantage? : sql server analysis services, ssas

0 Answers  

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---