Interested to Buy Any Domain ? << Click Here >> for more details...
How can we import and export using BCP utility?
- 1 Answers
- 6211 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 |
Explain what are the tasks that loadmanger process will do?
What is data merging, data cleansing and sampling?
What is the difference between data warehouse and operational systems?
What is data mart in data warehouse?
What are modeling tools available in the market?
What is the difference between static cache and dynamic cache?
What is the difference between drill through and masterdetail reports?
What is static and local variable?
Explain some of modeling tools available in the market?
How to create context?
How can we transform row to column?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Teradata 
