Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip of the Day
Language: Enterprise
Expertise: All
Apr 30, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

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.



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