SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1137 Page Views: 

What is the purpose of bcp utility?



Posted By: Avi Date: 1 October 2010 11:52:07 AM
 Answer:

bcp utility copies bulk data between an instance of SQL server database and user defined file format. This utility can be used to import as well as export data into the tables and out of the tables respectively. For eg If you want to convert SQL file to plain text file and copy it to other application then it can be done as follows:- bcp out databasename.dbo.tablename Filename.txt -T -C


Posted By: avibtech


Date: 1 October 2010 11:52:07 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image AVBsfd
Related Questions
SQL Server : What are Constraints and how many constraints are supported by SQL Server?

What are Constraints and how many constraints are supported by SQL Server?

Constraints are the properties assigned to a single column or multiple columns to prevent inconsiste....
Category: SQL Server Date: 10/1/2010 11:06:06 AM
SQL Server : Is SET and SELECT the same thing?

Is SET and SELECT the same thing?

No. Both are used to assign value to the variables, but are different. SET uses ANSI standard while ....
Category: SQL Server Date: 10/1/2010 11:05:06 AM
SQL Server : If database is already opened and work is being done on it , is it possible to rename the database at that time?

If database is already opened and work is being done on it , is it possible to rename the database a....

No, if someone is using the databse then the datbase can't be renamed . For renaming the database we....
Category: SQL Server Date: 10/1/2010 11:04:06 AM
SQL Server : How the database can be renamed?

How the database can be renamed?

sp_rename 'olddatabasename' 'newdatbasename'
Category: SQL Server Date: 10/1/2010 11:03:06 AM
SQL Server : Having a table which is refrenced by Foreign Key. Can the TRUNCATE command be executed on that table?

Having a table which is refrenced by Foreign Key. Can the TRUNCATE command be executed on that table....

No,it is not possible . Because according to refrential integrity the table with the foreign can not....
Category: SQL Server Date: 10/1/2010 11:02:06 AM