How can we import and export using BCP utility?



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

What is surrogate key? Explain with examples.

0 Answers  


What is the difference between metadata and data dictionary?

0 Answers  


in general which algorithms for used?

0 Answers  


What are session timeout and application timeout? Where we have to do this process?

0 Answers  


What is an er diagram?

0 Answers  


Can you explain how analysis service works?

1 Answers  


What is a ETL/ How does Oracle support the ETL process?

1 Answers  


Why denormalization is promoted in universe designing?

0 Answers  


How would you write a left join statement to return a result set of movie.title�s and director.name�s?

0 Answers  


How does data mining and data warehousing work together?

2 Answers  


Explain difference between view and materialized view?

0 Answers  


what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

0 Answers   IBM,


Categories