What is the command line syntax for the BCP?
Posted Answers
The executable file BCP.EXE is located in the BINN folder under the SQL Server directory. The syntax for the BCP command-line utility is as follows:-
Bcp [[database_name.]owner.]table_name {in | out | format} datafile-name [options]
Where the following are ture:
[[database_name.]owner.]table_name is the qualified name of the table or view that’s to supply exported rows or receive imported rows.
{in | out | format} specifies the direction of the data transfer; if a format is specified, a format file is generated for the given table or view.
Datafile-name is the path and filename of the source or destination file. UNC names are supported.
Answer by: Anonymous