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

what are triggers? : Sql server database administration

863

---

What are functions in the sql server?

1127

---

What is correlated subquery in sql server?

1016

---

‘Order by’ is not allowed in a view how can you sort information from a view?

1019

---

Explain transaction isolation levels in sql server?

1035

---

Where sql server usernames and passwords are stored in a sql server?

933

---

What does it mean to invest in the index?

905

---

Can we use where clause in union?

1001

---

What is dbcc updateusage?

1151

---

How do I get to sql server configuration manager?

952

---

How to reaname table name without using sp_Rename in sql server..?

936

---

What are xml indexes?

892

---

What is the difference between commit and rollback?

876

---

Do you know how to implement service broker?

885

---

Tell me what is sql profiler?

979

---