How can we import and export using BCP utility?
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 surrogate key? Explain with examples.
What is the difference between metadata and data dictionary?
in general which algorithms for used?
What are session timeout and application timeout? Where we have to do this process?
What is an er diagram?
Can you explain how analysis service works?
What is a ETL/ How does Oracle support the ETL process?
Why denormalization is promoted in universe designing?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
How does data mining and data warehousing work together?
Explain difference between view and materialized view?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc