Interested to Buy Any Domain ? << Click Here >> for more details...
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
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is order of B+tree?
Explain system views?
Explain what is public role in sql server?
What is logon trigger?
How do I clean up sql server transaction log?
What does man by sql wildcard characters in sql server?
Which database stores information about replication?
What is rolap and its advantage? : sql server analysis services, ssas
How to throw custom exception in Stored Procedure?
What is collation?
What is the difference between NOROW and LOCKROW?
How to disable triggers using "disable trigger"?
What are different types of raid levels?
What is row_number()?
What is the significance of master, tempdb and model databases?
