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

Can you type more than one query in the query editor screen at the same time?

1068

---

can a table be moved to different filegroup? : Sql server administration

1019

---

How to defragment table indexes?

1038

---

what are user defined datatypes and when you should go for them? : Sql server database administration

1062

---

What is relationship? What number of sorts of relationship are there?

1223

---

What is de-normalization and what are some of the examples of it?

1019

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1064

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

1024

---

What is difference between sql and sql server?

1081

---

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

1153

---

What is data source in connection string?

956

---

What’s the use of custom fields in report?

986

---

What is auditing in sql server?

964

---

How do I connect to sql server database?

1066

---

What is bcp? When does it use?

988

---