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 the types of indexing?

1084

---

Explain how many normalization forms?

1037

---

What command do we use to rename a db, a table and a column?

929

---

Is null in sql server?

996

---

What is xdr?

996

---

Can a table be created inside a trigger?

974

---

Where can you add custom error messages to sql server?

1130

---

What is executereader?

962

---

What should be the fill factor for indexes created on tables? : sql server database administration

1144

---

What is sub query and its properties?

976

---

how many no of arguments can be passed in procedures and functions

5570

---

Explain database normalization?

1234

---

Explain nested join?

990

---

How to disable stored procedure sql server?

1610

---

Find nth lowest salary or get nth lowest salary?

1029

---