Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
joy
Starting Member
5 Posts |
Posted - 2005-06-01 : 03:39:05
|
Is there any way to extract the header info in the first row while extracting data from a table using BCP. |
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-06-01 : 05:11:42
|
[url]http://weblogs.sqlteam.com/brettk/archive/2005/04/13/4395.aspx[/url]rockmoose |
 |
|
joy
Starting Member
5 Posts |
Posted - 2005-06-01 : 07:31:33
|
Thanks For the reply. But I need some thing where i don't need to run a SP. Is there any parameters for BCP which will generate the header info in the first line. |
 |
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-06-01 : 07:39:35
|
No.rockmoose |
 |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-01 : 08:35:42
|
osql can create column headers, but you don't have the control over formatting that bcp does. Look in Books Online under "osql" to learn more. |
 |
|
|
|
|