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 |
|
Clages1
Yak Posting Veteran
69 Posts |
 Posted - 2006-12-05 : 10:12:04
|
| Hi againusing this query in query analizer works finebut (always but) BCp puts 09 (tab character) between fields even i dont use -t parameter.then i get123XnameXadress where X is a tab characteri want 123nameadress how can i fix it? I dont want to use any terminator between fieldtksagainsClagesSelect * into tmparea from (select * from area) TExec master..xp_cmdShell 'bcp "Select * from teste.dbo.tmparea" queryout "C:\area.txt" -S Clages1 -U"sa" -P "teste" -c -T'Drop table tmparea |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-05 : 10:16:06
|
| Exec master..xp_cmdShell 'bcp "Select col1+col2+col+...+colX from teste.dbo.tmparea" queryout "C:\area.txt" -S Clages1 -U"sa" -P "teste" -c -T'Peter LarssonHelsingborg, Sweden |
 |
|
|
Clages1
Yak Posting Veteran
69 Posts |
Posted - 2006-12-05 : 10:32:37
|
| ok, But in this case i will have to convert all fields to Chari will fix one thing and broke other, because i have in this querya several sort of field (date, Int, char, varchar, etc)and i need all the field aligned.is there another solution?tksC. lages |
|
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
I dont want to use Field terminator in BCP