Interested to Buy Any Domain ? << Click Here >> for more details...
How can we import and export using BCP utility?
- 1 Answers
- 6312 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 what is the difference between stop and abort?
How to calculate fact table granularity?
Explain when do we analyze the tables? How do we do it?
Code the tables statement to produce a multi-level frequency?
What is hybrid slowly changing dimension?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
How can we run the graph?
What is the difference between metadata and data dictionary?
Explain hybrid slowly changing dimension?
Explain about core dimension, balanced dimension, and dirty dimension?
What is metadata in context of a datawarehouse and how it is important?
What are the different methods of loading dimension tables?
Teradata 
