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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Save Query with its columns

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-11-19 : 08:21:58
Mmatau writes "regarding bcp ' http://www.sqlteam.com/item.asp?ItemID=4722', can you save that query with is own columns because it only save the results and leave the name of the colums"

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-11-19 : 12:25:59
IMPOSSIBLE!!??
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-11-19 : 20:22:41
Not at all impossible, if you use osql instead. It generates results just like Query Analyzer does, and can output them to a file just like bcp. You can specify the -h parameter to turn column names/headings on or off. See Books Online under "osql" for more information.

Stoad-

Please don't post something is "impossible" without any explanation or research. You're simply discouraging people from seeking a solution.
Go to Top of Page

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-11-20 : 06:35:17
LOL Rob,

here you got sniped twice:

1. I put in 'my answer' 2 (!!) question marks;

2. The asker meant only BCP utility.
Go to Top of Page
   

- Advertisement -