September 18, 2008 at 11:44 pm
How do i insert O'Brien in Name field of Table
September 19, 2008 at 12:15 am
SET QUOTED_IDENTIFIER { ON | OFF }
When SET QUOTED_IDENTIFIER is OFF, literal strings in expressions can be delimited by single or double quotation marks. If a literal string is delimited by double quotation marks, the string can contain embedded single quotation marks, such as apostrophes
September 19, 2008 at 8:05 am
shriya (9/18/2008)
How do i insert O'Brien in Name field of Table
Also read this
http://sqlblogcasts.com/blogs/madhivanan/archive/2008/02/19/understanding-single-quotes.aspx
Failing to plan is Planning to fail
September 23, 2008 at 5:44 am
insert into table select 'O''rean'
replace single quote with double quote
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply