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 |
Fact table is in normalized or de-normalized form?
What is the difference between metadata and data dictionary?
For faster process, what we will do with the universe?
What is the purpose of Dataware Control?
What is difference between model & package?
What is called dimensional modelling?
What is real-time datawarehousing?
Tell me what is full load & incremental or refresh load?
Can we have multiple application.cfm file in an application?
Briefly state different between data ware house & data mart?
What are the different types of segments?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?