SQL question

["Arnett, Matt" <Matt.Arnett@xxxxxxxxxx>]

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.