Answer Posted / Manoj Kumar Verma

{"scalar_subquery": "A scalar subquery is a subquery that returns a single value.n"distinct_scalar_subquery": "A distinct scalar subquery is a scalar subquery with the DISTINCT keyword, used to return unique values."}

Does view occupy space?

1005

---

What are the properties of the transaction?

1069

---

How do I find the sql server version?

1099

---

Can we shrink data file in sql server?

1118

---

List the ways in which dynamic sql can be executed?

1076

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1122

---

What is sql or structured query language?

1213

---

What is the difference between for xml raw and for xml auto?

1108

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

---

How to convert numeric expression data types using the cast() function?

1142

---

What are the different types of subquery?

1227

---

Why we use the openxml clause?

1064

---

Equi join and non equi join is possible with sql server?

1121

---

Why should you use or avoid select * statements?

1103

---

How to remove duplicate rows from table except one?

1077

---