 |
How to export table or Query output to a file using BCP
|
| Total Hit (2813) |
To export Query result to a file use following command to your command prompt
«code LangId=6»EXEC master..xp_cmdshell
'bcp "select * from pubs..authors" queryout c:\authors.txt -c -Usa -Pmypassword'«/code»
To export table to a file use following command to your command prompt
«code LangId
....Read More |
Rating
 |
|
|
|
|
|
|
|
How to create Format File using BCP command
|
| Total Hit (22024) |
When you bulk import into a SQL Server table or bulk export data from a table, you can use a format file to store format information for each field in a data file relative to that table. A format file provides a flexible system for writing data files that requires little or no editing to comply with
....Read More |
Rating
 |
|
|
|
Understanding BCP/BULK COPY Format Files
|
| Total Hit (1144) |
In Microsoft SQL Server 2000 and earlier, bulk exporting and importing works with a single type of format file. This is supported in Microsoft SQL Server 2005. SQL Server 2005 also supports XML format files as an alternative. To distinguish format files of the original type, they are called non-XML
....Read More |
| Rating
|
|
|
|
Importing and Exporting Data with SQL Server
|
| Total Hit (1268) |
Transferring data, whether into or out of a database, can be a complex process. SQL Server provides several tools that help you in a variety of situations, including the Bulk Copy Program, the Select statement, the Transfer Manager, and Query results. This chapter examines those options, and times w
....Read More |
| Rating
|
|