How can we import and export using BCP utility?
- 1 Answers
- 5819 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 are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Explain vldb?
What is recovering sessions?
Name a few sectors which use data warehousing?
What's a Cube in Rolap?
What is a real-time data warehouse?
1.WHAT IS DATA MART ?
Explain why fact table is in normal form?
What is metadata in context of a datawarehouse and how it is important?
What is a hash cluster?
Explain what are the advantages and disadvantages of reporting directly against the database?
What is Operational Data Store?
Teradata 
