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

What are tables in sql server?

1015

---

Where are SQL server users names and passwords are stored in sql server?

1245

---

How do I completely remove sql server instance?

1084

---

How would you use user_constraints table in DB?

993

---

How will you make an attribute not process? : sql server analysis services, ssas

1072

---

how you can configure a running aggregate in SSRS?

188

---

Why do we need different type of parameter?

1042

---

Write SQL queries on Self Join and Inner Join.

1140

---

What is the difference between functions and scalar functions?

1193

---

What are the types of table?

968

---

Explain primary key?

951

---

What is normalization of database? What are its benefits?

1014

---

What is the Difference Between Primary and Foreign Key?

992

---

How to list all objects in a given schema?

1043

---

What is update_statistics command?

1052

---