Answer Posted / rajkumar

SP_RENAME 'OLDTABLE NAME', 'NEW TABLE NAME'
eg:
SP_RENAME 'TBL_EMPLOYEE', 'TBL_EMP'

Explain about extended stored procedure?

677

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

926

---

Difference between DELETE and TRUNCATE?

790

---

Is it possible to replicate data from sql server to oracle? : sql server replication

745

---

What is the difference between delete and truncate statements?

746

---

---

what is difference between view and Dip.

2185

---

How to move database physical files in ms sql server?

691

---

What is order of B+tree?

859

---

Explain use of expression builder.

739

---

How many replicas are maintained for each sql azure db?

118

---

Tell me the difference between clustered and non-clustered index?

682

---

what authentication modes does sql server support? : Sql server database administration

714

---

Determine when to use stored procedure to complete sql server tasks?

713

---

Can a table have 2 foreign keys?

668

---

What are the key configuration files for sql server reporting services ?

150

---