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

What is scalar user-defined function?

996

---

What are the fixed server level roles? : sql server security

1052

---

Is BCNF better than 2NF & 3NF? Why?

1002

---

what purpose does the model database serve? : Sql server database administration

921

---

Write an sql query for deleting duplicate rows?

952

---

What are the new data types are introduced in sql 2000?

859

---

How to retrieve field values using mssql_result()?

1186

---

How to drop existing views from a database in ms sql server?

1039

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

915

---

How to concatenate two binary strings together?

1047

---

How to create indexed view?

985

---

What are wait types?

1019

---

How can I change procedure name in sql server?

973

---

What is abstracting periodical?

896

---

What are the built in functions in sql server?

917

---