Answer / Saurabh Dwivedi

OPENXML is an XML-related function in SQL Server that allows you to read and process XML data within T-SQL code. It provides a way to parse and query XML documents, extracting individual elements or values for further processing.

Define candidate key, alternate key, and composite key.

1 Answers  

---

How do I setup a sql server database?

1 Answers  

---

What is index in an assignment?

1 Answers  

---

Define views.

1 Answers  

---

How to list all objects in a given schema?

1 Answers  

---

Are semicolons required at the end of sql statements in sql server 2005?

1 Answers  

---

What is an index in a database?

1 Answers  

---

Tell me what is the significance of null value and why should we avoid permitting null values?

1 Answers  

---

explain different types of backups avaialabe in sql server? : Sql server database administration

1 Answers  

---

Explain about nested stored procedure?

1 Answers  

---

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

What is de-normalization in sql database administration? Give examples?

1 Answers  

---