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
Explain grouped cross tab?
What is bi?
What are the advantages of cold fusion?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain where do we use semi and non additive facts?
I have two universes created by two difference database can we join them in designer & report level? How
Explain the difference between view and materialized view?
What are the key features of chameleon that separates it from other algorithms?
Explain piconet?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Explain normalization?
Tell me what is degree of a relation?
Name a few sectors which use data warehousing?
What is your spectra photometer working principles?
What is the difference between power center & power mart?