How can we import and export using BCP utility?
- 1 Answers
- 5696 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 |
Explain bus schema?
What is a cube in data warehousing concept?
What is MODEL is Data mining world?
What is the difference between olap and oltp?
What is the difference between constraind base load ordering and target load plan?
Do you view contain data?
Which columns go to the fact table and which columns go the dimension table?
State any 5 of Cods guidelines of an OLAP system, brief description each?
Explain the differences between normalizer and normalizer transformation?
Is there any default username & pwd for bo designer & supervisor?
4.Explain Snowflkeschema ?
6 Answers EDS, HCL, IBM, iFlex, TCS,
What are the advantages of cold fusion?
Teradata 
