Wrox Programmer Forums
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 10th, 2005, 08:34 AM
Registered User
 
Join Date: Nov 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default BCP Syntax

I am trying to use the BCP utility to copy a stored procedure out to a text file.

1) Is there a way to include the field headers in the text file?
2) Is there a way to turn off the quotes between data?

So far, here is the syntax I have so far:
bcp "database..sp" queryout "c:\test.txt" -t, -Sserver -Uuser -Ppassword

Thank you,
JLFleming
 
Old August 10th, 2005, 12:28 PM
Friend of Wrox
 
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

Hi,
Please check the following URL:
http://msdn.microsoft.com/library/de...p_bcp_61et.asp

Om Prakash





Similar Threads
Thread Thread Starter Forum Replies Last Post
BCP Error lisa30 SQL Server 2000 5 October 11th, 2007 07:06 PM
BCP out errors, help please. munkee SQL Server 2000 4 August 3rd, 2007 09:14 PM
bcp error SpringSummer SQL Server 2005 1 July 12th, 2007 02:18 AM
bcp Danielk SQL Server 2000 3 June 12th, 2006 11:14 AM
Bcp utility jejyjose SQL Server 2000 1 October 16th, 2003 08:31 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.