Specifies the row terminator default is a newline (\n).Specifies the field terminator default is a tab (\t).Specifies the code page that is used to store character data defaults to SQL Servers standard code page.Quoted identifier specifies that the dbtable string will either contain quotes or brackets to delimit object names defaults to not being set.The data is 6x file format defaults to not being set.Non-text data is native format defaults to not being set.Data is unicode character defaults to not being set.Data is stored as character defaults to not being set.Data is stored as SQL Server's native type defaults to not being set.Specifies how many rows to import as one transaction defaults to all the file.Specifies the last row to load, or the last row to export defaults to all the rows.Specifies the first row from the file to load, or the first row from the table to export.If you do not specify a error file, SQL Server will print error information to the screen, but will not tell you what row caused the problem defaults to no errorfiles. A file that all records that generate errors will be copied to.Specifies the file that contains information defaults to no format file. The maximum number of errors before the bcp is aborted this parameter defaults to 10.The file to export/import you must specify the datafile.Specifies what the bcp is being used for.bcp can extract data from a query, the query must be enclosed in double quotes("query").The permanent table, global temporary table, or view to access.The following MouseOver illustrates the syntax of the bulk copy program. The parameters for the bcp program are similar to the bulk insert statement options. However, unlike the bulk insert statement, bcp can also be used to extract data from a table. Bulk copy program (bcp) can be used to load data from a file into a table.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |