Interested to Buy Any Domain ? << Click Here >> for more details...
How can we import and export using BCP utility?
- 1 Answers
- 6320 Views
- I also Faced
- E-Mail Answers
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 |
What Oracle features can be used to optimize my Warehouse system?
Explain which columns go to the fact table and which columns go the dimension table?
What are universe requirements?
What are the different methods of loading dimension tables?
Why facts table is useful in representing the data?
What are the other names given to data warehousing?
What is BCP?
What is the difference between power center and power mart?
Explain degenerate dimension table?
What is the 4 + 1 view model as it relates to system modeling?
Where the applications and where
can anybody mail me the FAQS for hyperion essbase amd planning
Teradata 
