将SQL Server表变成txt文件(国外英文资料).docVIP

将SQL Server表变成txt文件 Turn the SQL Server table into the TXT file Tutorial tips: the BCP utility is in Microsoft? SQL Server? 2000 instances and data files are reformatted in a user-specified format Method - : use the BCP command BCP utility The BCP utility in Microsoft? SQL Server? 2000 instances and data files are reformatted in a user-specified format. 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] [-n] [-n] [-v] [-v] [-v] [-v] [-v] [-v] [-v] [-v] [-v] [-v] [-v] [-v] [-v] [-v] [-v] [-v] [-v] [-q] [-c] [-c] [-t] [-t] [-r]] [-r row_term] [-i input_file] [-o output_file] [-a packet_size] [-s server_name [instance_name]] [-u login_id] [-p password] [-h] [-h] [-h] Parameter database_name The name of the database that is specified by the table or view. If not specified, the user defaults to the database. The owner The name of the table or view owner. The owner is optional if the user that performs the large capacity replication operation has a specified table or view. If a user who does not specify a owner and performs a large capacity replication operation does not have a specified table or view, then Microsoft? SQL Server? 2000 will return error messages and cancel large capacity replication operations. table_name It is the name of the destination table that copies the data to SQL Server (in) and the source table name of the data (out) from SQL Server. view_name It is the destination view name that copies the data to SQL Server (in) and the source view name from SQL Server replication data (out). Only the views of the same table are referenced by all of the columns for the purpose view. For more information on the limitations of copying data to views, see INSERT. The Query Is a transact-sql query that returns a result set. If the query to return multiple result sets, such as specified COMPUTE clause