How can we import and export using BCP utility?

Question Posted / guest

1 Answers
6413 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 are the possible data marts in retail sales?

0 Answers

What is called dimensional modelling?

0 Answers

Explain what is full load & incremental or refresh load?

0 Answers

If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?

3 Answers Extech, Principal Finance,

What are the various tools? Explain name a few?

0 Answers

What is operational data source (ODS)?

2 Answers

How to generate the cubes in framework manager?

0 Answers

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

0 Answers

Explain how are the dimension tables designed?

0 Answers

How can you set the client management?