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: All
Apr 29, 1999

Yet Another Wrinkle in BCP

It is now easy to create scripts using the functionality in T-SQL to automate the loading of data into SQL Server with the addition of the bulk insert command in T-SQL. The parameters expose all the same functionality of the BCP command line utility. The command can also be nested in a transaction and so allow for checking for dependencies before committing the inserts. However, the command only supports loading information into SQL Server. Writing from a table to a file still requires the command line version of BCP.
Joseph Lax
 
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