Answer / guest

A. One of the purposes of Extensible Markup Language (XML)
is to solve challenges like this, but until all
applications become XML-enabled, consider using our faithful
standby, the bulk copy program (bcp) utility.
This utility can do more than just dump a table; bcp also
can take its input from a view instead of from a table.
After you specify a view as the input source, you can limit
the output to a subset of columns or to a subset of rows by
selecting appropriate filtering (WHERE and HAVING) clauses.

More important, by using a view, you can export data from
multiple joined tables. The only thing you cannot do is
specify the sequence in which the rows are written to the
flat file, because a view does not let you include an ORDER
BY clause in it unless you also use the TOP keyword.

If you want to generate the data in a particular sequence or
if you cannot predict the content of the data you want to
export, be aware that in addition to a view, bcp also
supports using an actual query. The only "gotcha" about
using a query instead of a table or view is that you must
specify queryout in place of out in the bcp command line.

For example, you can use bcp to generate from the pubs
database a list of authors who reside in California by
writing the following code:

bcp "SELECT * FROM pubs..authors WHERE state = 'CA'"
queryout c:\CAauthors.txt -c -T -S

Answer / skybeaver

Use the BCP utility

bcp out Database.dbo.TableName FileName.txt -T -c

Can you type more than one query in the query editor screen at the same time?

0 Answers  

---

How exceptions can be handled in sql server programming?

0 Answers  

---

What is the difference between function and stored procedure in sql server?

0 Answers  

---

Can we call future method from trigger?

0 Answers  

---

What is service broker?

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

Do you know the capabilities of cursors?

0 Answers  

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

0 Answers   HCL,

---

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 the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

---

How do I find the query plan in sql server?

0 Answers  

---

What are extended events in sql server?

0 Answers  

---