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

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

0 Answers  

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

What is Covering Indexes? Plz explain with example

3 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

0 Answers  

---

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

What are the two modes of authentication in sql server?

0 Answers  

---

How to connect to a sql server using odbc_connect()?

0 Answers  

---

What is difference between join and natural join?

0 Answers  

---

What are the advantages of mirroring?

0 Answers  

---

How to perform key word search in tables?

0 Answers  

---