Answer Posted / 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
Is This Answer Correct ? | 29 Yes | 2 No |
Post New Answer View All Answers
How can I check if a view exists in a sql server database?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Explain about Joins?
What is the difference between varchar and nvarchar datatypes?
Tell me what are cursors and when they are useful?
How do I get to sql server configuration manager?
What is cdc in sql server?
Can we use where clause with group by?
How to transfer data from a cursor to variables with a "fetch" statement?
What happens when converting big values to integers?
How to add the custom code in Report?
Explain concepts of analysis services?
What does it mean to invest in the index?
What is update_statistics command?
What is the difference between clustered and non-clustered indexes in ms sql server?