Answer Posted / shardul negi

backup database <database name> to disk
= 'c:\<DatabaseName>.bak'

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

496

---

What is the xml datatype?

617

---

What is a with(nolock)?

565

---

What is the difference between insensitive and scroll cursor?

570

---

What are the basic functions for master, msdb, model, tempdb and resource databases?

545

---

---

What are functions in the sql server?

595

---

How many types of schemas are there?

521

---

What is rank function?

597

---

How do you delete duplicate rows in sql server?

498

---

What is indexing a document?

542

---

What is the purpose of forms?

483

---

What is the maximum size per database for sql server express?

547

---

What are the system database in sql server 2005?

545

---

what's the information that can be stored inside a bit column? : Sql server database administration

521

---

How to execute a sql statement using odbc_exec()?

564

---