Answer Posted / durgaprasad

sp_rename 'tablename.oldcolumnname','newcolumnname'

What are the difference between primary keys and foreign keys?

913

---

What is a transact-sql statement?

977

---

What happens when transaction log is full?

868

---

Can you type more than one query in the query editor screen at the same time?

949

---

How to backup encryption key ?

167

---

What is unpivot?

965

---

When I delete any data from a table, does the sql server reduce the size of that table?

955

---

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

820

---

What is “asynchronous” communication in sql server service broker?

958

---

What are drillthrough reports?

141

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1206

---

How to drop existing views from a database in ms sql server?

1038

---

What does this statement do @@rowcount?

920

---

How to list all user defined functions in the current database?

970

---

Can we call stored procedure in view in sql server?

859

---