How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

---

What is single-user mode?

0 Answers  

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

how many no of arguments can be passed in procedures and functions

1 Answers   ABC,

---

How to query multiple tables jointly?

0 Answers  

---

Explain Active/Active and Active/Passive cluster configurations

2 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

What is normalization? What number of normalization shapes are there?

0 Answers  

---

What does it mean to normalize a database and why would you do it?

0 Answers  

---

Explain forward - only cursors?

0 Answers  

---

What is the system function to get the current user's user id?

2 Answers   HCL,

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---