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