How can we import and export using BCP utility?
- 1 Answers
- 5503 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 can report net connect multiple datasource at a time in report creation time?
Ist the schema that a data warehouse system can implements.
What is drill-through?
What is an error log table in informatica occurs and how to maintain it in mapping?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain why dimenstion tables are denormalized in nature?
How to design file watch jobs?
How to use the tool Ontobulider
How many project sources we can create in metadata?
Explain er diagram?
What are cluster analysis in data warehousing?
Explain the main differences between star and snowflake schema?
Teradata 
