Answer Posted / guest

select * from tab where max(salary)

What is BCP? When does it used in sql server 2012?

1061

---

What are orphan records?

932

---

What is report rendering ?

157

---

How to write character string constants or literals in ms sql server?

1019

---

Explain use of expression builder.

1013

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1019

---

Explain about builtinadministrator?

1053

---

What command do we use to rename a database?

1078

---

Explain what is raid and what are different types of raid levels?

1024

---

Explain syntax for viewing, dropping and disabling triggers?

953

---

What is your recommendation for a query running very slow? : sql server database administration

1045

---

When should you use an instead of trigger?

955

---

Do you know what are the differences between lost updates and uncommitted dependencies?

1079

---

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

167

---

Can you explain full-text query in sql server?

1011

---