How can I create a plain-text flat file from SQL Server as
input to another application?
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / skybeaver
Use the BCP utility
bcp out Database.dbo.TableName FileName.txt -T -c
Is This Answer Correct ? | 0 Yes | 2 No |
What is efficiency data?
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C
What is the difference between commit and rollback?
What is #temp and @table variable in SQL server?
How to create an identity column?
What is similarity and difference between truncate and delete in sql?
How do I edit a procedure in sql server?
What is the difference between varchar and nvarchar?
How to execute function in stored procedure sql server?
What is a subquery in a select query statement in ms sql server?
Determine when to use stored procedure to complete sql server tasks?
what is trigger
1 Answers CarrizalSoft Technologies, NIIT,