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

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

What command is used to create a database in the sql server and how?

0 Answers  

---

Explain magic tables in sql server?

0 Answers  

---

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

---

Which TCP/IP port does SQL Server run on?

2 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

---

How to skip remaining statements in a loop block using continue statements?

0 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

---

What are 3 ways to get a count of the number of records in a table?

0 Answers  

---

How to find the list of fixed hard drive and free space on server?

0 Answers  

---

What is sub query and its properties?

0 Answers  

---

Explain difference between cross join and full outer join?

0 Answers  

---