That worked!
Insert into [dbo].[MY_TABLE] ( [id], [directions])
Values (1, 'Follow these steps:'+char(13)+
'1) step 1…'+char(13)+
'2) step 2…'+char(13)+
'3) step 3…'+char(13))
-----Original Message-----
From: Abdul Habra
[mailto:ahabra@xxxxxxxxx]
Sent: Friday, October 14, 2005 1:45 PM
To: Arnett, Matt; users@xxxxxxxxxx
Subject: Re: [cinjug-users] SQL
question
how about using the char(13) function in sql server?
"Arnett, Matt"
<Matt.Arnett@xxxxxxxxxx> 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.
Thank You,
Abdul Habra
Yahoo!
Music Unlimited - Access over 1 million songs. Try it free.