I want to dump a tale into a text file I am using following command -
bcp tablename out myTable.dat -T -C
But got error it says incorrect symbol near bcp.
I am not sure why I am getting this.
-
see here - simple-talk.com/sql/database-administration/…user195488– user1954882011-09-09 00:31:20 +00:00Commented Sep 9, 2011 at 0:31
-
bcp is a command-line program. You need to specify the database and owner, and can run it from your workstation (might need to provide -S, -U and -P parameters for authentication). I usually use -c -t to produce tab-delimited files that can be loaded or pasted into Excel easily.Jason Goemaat– Jason Goemaat2011-09-09 01:47:23 +00:00Commented Sep 9, 2011 at 1:47
Add a comment
|
1 Answer
From @Code Monkey's Link : http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/
try this
declare @sql varchar(8000)
select @sql = 'bcp [dbname].[dbo].[tablename] out myTable.dat -c -t, -T -S'+ @@servernameexec
master..xp_cmdshell @sql
where dbname is the name of your database, and replace dbo with the name of the schema if not dbo
