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

Explain few of the new features of sql server 2008 management studio

0 Answers  

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

Explain database normalization?

0 Answers  

---

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

---

What is inline variable assignment?

0 Answers  

---

Tell me what is a linked server?

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 Answers  

---

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

---

How will you find out if there are expensive SQL statements running or not?

0 Answers   Atos Origin,

---

What is difference between rownum and rowid?

0 Answers  

---

difference between truncate, delete aur drop?

2 Answers  

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---