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 is the difference between the application object and session object?

1121

---

What is tablesample?

1176

---

Explain indexed views?

1027

---

How to insert multiple rows with one insert statement in ms sql server?

1180

---

Explain where clause?

1033

---

How to list all user names in a database?

1092

---

Explain system functions or built-in functions? What are different types of system functions?

1041

---

When is the use of update_statistics command?

1057

---

How to find which stored procedure is currently running in sql server?

1042

---

How ssrs maintain security?

1132

---

Do you know what are the ways available in sql server to execute sql statements?

1082

---

Which table keeps information about stored procedures?

983

---

How do I setup a local sql server database?

1070

---

What are orphan records?

986

---

What is collation sensitivity?

1134

---