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 |
What is fact less fact table? Where you have used it in your project?
How can we run the graph? How can we schedule the graph in unix?
What are the key features of chameleon that separates it from other algorithms?
what is parallel query?
What is called dimensional modelling?
Explain what are the advantages data mining over traditional approaches?
What is the difference between Oracle Express and Oracle Discoverer?
Explain what is power center repository?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
What's a Cube in Rolap?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What is data analysis? Where it will be used?