Answer Posted / vikneswaran

number

Explain how would you store your query in an SSRS report or a Database server?

118

---

Explain concepts of analysis services?

906

---

What is multi-statement table-value user-defined function?

960

---

Explain table valued parameters in sql server? Why tvp used?

981

---

Explain syntax for dropping triggers?

904

---

Create and insert into temp table in sql server?

995

---

When is the use of update_statistics command?

976

---

Which tools are available to manage SQL Azure databases and servers?

113

---

How can we rewrite sub-queries into simple select statements or with joins?

941

---

What is the meaning of sql server?

956

---

How to convert numeric expression data types by assignment operations?

1023

---

What is for xml in sql server?

1013

---

What is the use of =,==,=== operators?

977

---

Differentiate between delete and truncate.

1019

---

Describe how to use linked server?

960

---