Answer Posted / rohit kumar singh

update & delete are two magic tables.
(a)update
insert and update
(b)delete

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

876

---

What are unicode character string data types in ms sql server?

1149

---

What are the differences between stored procedure and the dynamic sql?

1030

---

what is normalization? : Sql server database administration

1022

---

Can we use having clause without group by?

931

---

Explain what are partitioned views and distributed partitioned views?

893

---

Find columns used in stored procedure?

938

---

How do I partition a table in sql server?

988

---

If a table does not have a unique index, can a cursor be opened on it?

874

---

What are the differences between clustered and non-clustered index?

957

---

What is in place upgrade in sql server?

990

---

What is extent? Types of extents?

1089

---

What do you understand by a view? What does the with check option clause for a view do?

954

---

Explain about analysis services?

983

---

What different steps will a sql server developer take to secure sql server?

933

---