SQLCMD using -s switches - SQL Server Forums

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 2005 Forums

Transact-SQL (2005)

SQLCMD using -s switches

Author

Topic

bendertez
Yak Posting Veteran

94 Posts

Posted - 2007-09-19 : 09:15:43

Is there any way of outputting a txt file using SQLCMD (-o), using the -s switch that will get rid of all column seperators.

I basically want the export file format to have no seperators or delimiters, just lines of data

i.e
1 2 3 4 5 6 or 1,2,3,4,5,6

to be
123456

Thanks

bendertez
Yak Posting Veteran

94 Posts

Posted - 2007-09-19 : 10:06:04

Its OK I found it myself

the syntax is -s""

for future reference

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources