How can we import and export using BCP utility?

Question Posted / guest

1 Answers
5317 Views
I also Faced
E-Mail Answers

How can we import and export using BCP utility?..

Answer / kishore

Import to test file:-
--------------------
bcp "SELECT ProcContent FROM <DBName>.dbo.NewProc order by
ID" queryout C:\NewProc.sql -c -S <ServerName> -T

If we can run(dos prompt) above statement in set of records
are store into c:\newproc.sql file.

Export from File:-
-----------------
BULK INSERT myTestCharData FROM 'C:\myTestCharData-c.Dat'
WITH ( DATAFILETYPE='char', FIELDTERMINATOR=',');

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More Data Warehouse General Interview Questions

Explain what is full load & incremental or refresh load?

0 Answers

in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do

1 Answers IBM,

Explain some of modeling tools available in the market?

0 Answers

How to drill through from a powerplay cube to reportnet?

0 Answers

What are Aggregate tables?

0 Answers

What is a star schema? Why does one design this way?

3 Answers

What are the main steps to build the data warehouse?

0 Answers

How to handle multi value dimensions?