Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Advanced
Mar 12, 2002

Dynamically Building the BCP Command Line Text Using the Query Analyzer


This is the easiest way:
 
Select "bcp " + db_name() + ".." + name +
" out c:\temp\" + name + ".txt /c -t\t -SserverName_
 -Usa -Ppassword
/b1000"
from sysobjects
where type = "U"
order by name

output will be like this we can use this as command _
line arguement for
getting bcp out.

bcp pubs..authors out c:\temp\authors.txt
/c -t\t -SserverName -Usa -Ppassword /b1000
bcp pubs..discounts out c:\temp\discounts.txt
/c -t\t -SserverName -Usa -Ppassword /b1000
Somaiah Manukonda
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date