BCP MEANS BULK COPY PROGRAM.
The bcp utility bulk copies data between an instance of Microsoft SQL Server 2005 and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into Microsoft SQL Server tables or to export data out of tables into data files.
SYNTAX FOR BCP
bcp databasename.schemaname.tablename out filename -T -c
or
bcp databasename.schemaname.tablename out "path" -T -c
T means trusted connection
bcp AdventureWorks.Sales.Currency out "Currency Types.dat" -T -c
the below fig shows the bcp command
The output file is shown below
The bcp utility bulk copies data between an instance of Microsoft SQL Server 2005 and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into Microsoft SQL Server tables or to export data out of tables into data files.
SYNTAX FOR BCP
bcp databasename.schemaname.tablename out filename -T -c
or
bcp databasename.schemaname.tablename out "path" -T -c
T means trusted connection
bcp AdventureWorks.Sales.Currency out "Currency Types.dat" -T -c
the below fig shows the bcp command
The output file is shown below
No comments:
Post a Comment