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
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What are the different ways to represent the loading of dimension tables?
What is the difference between olap and oltp?
What is Discover and Execute in XMLA?
Explain why dimenstion tables are denormalized in nature?
Can decision tree be implemented using SQL?
What is surrogate key? Explain with examples.
Explain me what are conformed dimensions?
Explain is olap databases are called decision support system true/false?
What are the key features of chameleon that separates it from other algorithms?
What is metadata in context of a datawarehouse?
Explain differences between star and snowflake schemas?
What is Analysis Services?
What is a hash cluster?
Explain the data types present in bo n wht happens if we implement view in the designer n report?