December 3, 2001 at 12:49 pm
posted from user:
How can I solve this problem, Example:
Create Table Test (ID integer, address char(40))
I like insert a data like this
ID=1
address=O'donnell 74
or
ID=2
address=2" size
insert into test(ID, address) values(1,'O''donnel')?
Brian Lockwood
President
LockwoodTech Software
Brian Lockwood
President
ApexSQL - SQL Developer Essentials
December 3, 2001 at 9:09 pm
Normally you handle single quotes by doubling them - that is using the replace function to replace any instance of a char(39) with 2 char 39's. Double quotes are ok if inside single quotes. They also work on the ends of the string - depending on your quoted_identifier setting.
Strangely enough, having the single and double quote caused us to NOT be able to post a reply! Have to track down which still.
Andy
December 3, 2001 at 11:01 pm
Interesting - thought I replied to this too. Didn't get an error.
Cursors never.
DTS - only when needed and never to control.
December 4, 2001 at 3:41 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy