将SQL Server表变成txt文件（Turn the SQL Server table into a TXT file）.docVIP

将SQL Server表变成txt文件（Turn the SQL Server table into a TXT file） Turn the SQL Server table into a TXT file Tutorial tip: BCP utilities repeat data in a user specified format between Microsoft, SQL, Server, 2000 instances, and data files Method: using the BCP command BCP utilities The BCP utility returns data in a user specified format between Microsoft, SQL, Server, 2000 instances, and data files. grammar Code: BCP {[[database_name.][owner].]{table_name view_name} | | query} {in out queryout format} data_file | | | [-m, max_errors], [-f, format_file], [-e, err_file] [-F, first_row], [-L, last_row], [-b, batch_size] [-n] [-c] [-w] [-N] [-V (60 | 65 | 70)] [-6] [-q], [-C, code_page], [-t, field_term], [-r, row_term] [-i, input_file], [-o, output_file], [-a, packet_size] [-S, server_name[instance_name]], [-U, login_id], [-P, password] [-T], [-v], [-R], [-k], [-E], [-h, hint [..., n]]] Parameter database_name The name of the database in which the table or view is specified. If not specified, the default database for the user. Owner The name of the table or view owner. Owner is optional if the user performing the bulk copy operation has the specified table or view. If the user who does not specify owner and performs bulk replication does not have the specified table or view, the Microsoft SQL Server 2000 will return error information and cancel the bulk copy operation. Table_name Is the destination table name for copying data to SQL Server (in), and the source table name for copying data from SQL Server (out). View_name The data is copied to the SQL Server (in) to the name of the view, and copy the data from the SQL Server (out) source view name. Only the views of the same table referenced by all columns can be used as destination views. For more information about data replication to view restrictions, see INSERT. Query Is a Transact-SQL query that returns a result set. If the query returns multiple result sets, such as the SELECT statement specifying the COMPUTE clause, o