Matt,
I know with MySQL, you can actually include carriage returns in the
appropriate value field of the insert and they will be preserved. Not
sure if that'll work in your case as I'm not familiar with SQLServer.
It's worth a shot though.
-Shane
Arnett, Matt wrote:
Does anyone know how to preserve carriage returns when scripting
INSERT SQL statements to a text file to be executed back into a
database? I have a field of type TEXT and my java code is able to
correctly insert and retrieve the data with carriage returns (which
amazed me in the first place). But I need to create a plain text file
to be able to push this data to different environments. But I have
not found any SQL which can specify special chars like carriage returns.
This is with MS-SQL Server 2000 but we will probably be using Oracle
10g too.
Thanks,
-Matt
This e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are
not a named addressee you are hereby notified that you are not
authorized to read, print, retain, copy or disseminate this
communication without the consent of the sender and that doing so is
prohibited and may be unlawful. Please reply to the message
immediately by informing the sender that the message was misdirected.
After replying, please delete and otherwise erase it and any
attachments from your computer system. Your assistance in correcting
this error is appreciated.
|