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

What is reportserver and reportservertempdb ?

152

---

do you know how to configure db2 side of the application? : Sql server database administration

1041

---

What is acid mean in sql server?

1119

---

Can we call future method from trigger?

938

---

What is a data source file?

974

---

What do you mean by a Composite primary key?

1103

---

What is the difference between a "where" clause and a "having" clause?

1160

---

What’s the use of custom fields in report?

944

---

Is there any difference between the primary key and unique key?

999

---

What is default constraint?

995

---

What is the difference between NOROW and LOCKROW?

2837

---

What is scrollable cursor?

1041

---

What are user defined functions in ms sql server?

999

---

State the difference between local and global temporary tables?

1119

---

What is database isolation in sql server? : sql server database administration

1106

---