Comment
The value of the calculated column or TimeStAMP column will be ignored in the data file to be imported, and the SQL Server 2000 automatically assigns. If the data file does not include the value of the calculated column or TimeStAMP column, the available format file specifies the calculation column and the TimeStAMP column that should be skipped in the table when importing data; SQL Server will automatically assign the column.
Calculating columns and TimeStamp columns often copied from SQL Server to a data file.
SQL Server identifiers (including database names, table names, or view names, login, and passwords) can include characters such as embedded spaces and quotes. When the identifier or file name containing a space or quotation is specified at the command prompt, it is necessary to cross the identifier in double quotes (""). In addition, for the name of the owner, table or view of the embedded space or quotation, the -Q option can be specified, or the name of the owner, the table, or the view is enclosed in both brackets ([]) in double quotes.
For example, there is a table Jane's ORDERS in the Northwind database, which is owned by the user Jane Doe. To use the login Jane DoE and password Go DBA to copy the table from the NorthWind database to the Orders.txt file, perform one of the following commands:
BCP "Northwind.jane Doe.jane's Orders" OUT "Jane's ORDERS.TXT" -c -q -u "jane doe" -p "go dba"
BCP "Northwind. [Jane's Orders]" Out "Jane's Orders.txt" -c -u "jane doe" -p "go dba"
