Interested to Buy Any Domain ? << Click Here >> for more details...
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
What a static and local variable?
What is a functional dependency f said to be minimal?
Is there any rownum object from which we can do this?
Explain the definition of normalized and denormalized view and what are the differences between them?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Which component has onread method and what it is used for?
What are the various file formats involved in reportnet?
Where the applications and where
Can decision tree be implemented using SQL?
What are universe requirements?
What is freehand sql?
What is the metadata extension?
How can you clear the cache?
what are the others of "bad files" and "discard files" when using sql*loader?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
