how to get only result in file

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

SQL Server Administration (2005)

how to get only result in file

Author

Topic

AdiI
Starting Member

31 Posts

Posted - 2009-12-11 : 06:39:49

hello
i have a table i wanted to spool all results in file. but i also wanted to place a delimiter after each column what is the best way to this.

adeel

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-11 : 11:39:35

I use bcp.exe. You could also use SSIS or the import/export wizard.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources