Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Bulk Insert into text field in SQL 2008 Management express Expand / Collapse
Author
Message
Posted Monday, March 15, 2010 7:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 4:26 AM
Points: 156, Visits: 19
Hi,
I have a table called TESTOUPUT in Oracle 10g and it contains 3 columns
ID_ VARCHAR2(7),
TEXT CLOB,
PROCESSED NUMBER
and same table I have created in SQL 2008 Express.
now I want to copy the data in CLOB of Oracle to TEXT field
How should I do this.
Format of my CLOB is as below: -
=============================================================
{1:F01SGL1XXXXXXXX0000000000}{2:I541ABCIBHBMXXXXN}{3:{108:1212}}{4:
:16R:GENL
:20C::SEME//RS5100801
:23G:NEWM
:98C::PREP//20100223094459
:16S:GENL
:16R:TRADDET
:98A::SETT//20100227
:98C::TRAD//20100219090000
:90B::DEAL//ACTU/EUR10,
:35B:ISIN ES0113900J37
BANCO SANTANDER
:16S:TRADDET
:16R:FIAC
:36B::SETT//UNIT/5000,
:97A::SAFE//REC050
:16S:FIAC
:16R:SETDET
:22F::SETR//TRAD
:22F::STCO//PART
:16R:SETPRTY
:95P::SELL//AAALSARI
:97A::SAFE//76767676
======================================================
Please help me as SQL 2008 doesn't support the Query Analyzer capabilities.
Thanks,
Sandeep
Post #882951
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse