Answer Posted / 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 |
Post New Answer View All Answers
What are the types of dimensional modeling?
What are parallel querys and query hints?
How do you setup Lo-cockpit?
Explain what are the different types of join operations?
What is a core dimension?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Explain Association algorithm in Data mining?
Explain why fact table is in normal form?
Explain what is the difference between stop and abort?
What is analytical or analytic mean?
What is load manager?
Explain what are the different types of data warehousing?
Explain differences between star and snowflake schemas?
What are the types of partitioning?
Why should you put your data warehouse on a different system than your oltp system?
