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 differences between star and snowflake schemas?
What are the steps of implementing data warehousing?
explain about dirty dimension?
What are the different problems that ?Data mining? can solve?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
How to generate the cubes in framework manager?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Explain ddl (data definition language)?
Explain what are the various file formats involved in reportnet?
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?
Explain about core dimension,
Explain what is the difference between powerplay transformer and power play reports?
What is difference between e-r modeling and dimensional modeling?
What is meant by metadata in context of a data warehouse?
What should I have in mind when building olap solution from scratch?