Interested to Buy Any Domain ? << Click Here >> for more details...
How can we import and export using BCP utility?
- 1 Answers
- 6406 Views
- I also Faced
- E-Mail Answers
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 |
What is a Data Cube?
How do we design a universe?
What is metadata in context of a datawarehouse?
what is user variable in affinium campaign? and some real time examples.
Explain where do we use semi and non additive facts?
Explain a mapping, session, worklet, workflow, mapplet?
Tell me what is full load & incremental or refresh load?
What are vaious etl tools in the market?
What are the differences between star and snowflake schema?
Explain how to generate iqd file from framework manager?
Why null values are mapped as 0 in fact tables?
Explain the importance of data warehouse?
Teradata 
