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 is similarity and difference between truncate and delete in sql?

1101

---

What are the advantages of stored procedure in sql server?

892

---

what are triggers? : Sql server database administration

905

---

Do you know clustered and non-clustered index?

979

---

What is the difference between an index and a unique index?

1001

---

What is update locks?

887

---

What is set nocount on?

939

---

what information is maintained within the msdb database? : Sql server administration

973

---

What are various limitations of the views?

1053

---

1 01 101 01010

2054

---

What is a fan-out query in SQL Azure?

121

---

User wants only to display only pdf as export option in report manager. How to achieve this?

262

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1111

---

why would you call update statistics? : Sql server database administration

1088

---

When would you use sql joins?

960

---