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

How does normalization work?

904

---

How can I check that whether automatic statistic update is enabled or not?

1028

---

What is the difference between a function and a stored procedure?

1052

---

Distinguish between commit and rollback?

943

---

Do you know clustered and non-clustered index?

966

---

Define the one-to-one relationship while designing tables.

889

---

What are different types of table joins?

991

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1952

---

Why is the need for data conversion transformations?

1036

---

How do we synchronize On-Premise SQL server with SQL Azure?

120

---

What is the difference between web edition and business edition?

111

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

957

---

Describe in brief system database.

1001

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1046

---

How to populate a table in sql server?

945

---