|
|
Posted by Dan Guzman on 11/09/06 13:10
To add on to Eland's response, the ANSI standard QUOTED IDENTIFIER ON allows
you to use SQL Server features line indexes on views and computed columns.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<othellomy@yahoo.com> wrote in message
news:1163056886.515598.327620@h48g2000cwc.googlegroups.com...
> Nevermind. Following worked:
> SET QUOTED_IDENTIFIER OFF
> insert mytable values (3,"'",getdate())
>
> othell...@yahoo.com wrote:
>> How do I insert a single quote ' into a table? For example:
>> Insert mytable values (1,''')
>> I get an error message.
>>
>> Any ideas? The server does not recognize double quote (why? is this
>> tsql, ansi?), otherwise I could have written it as:
>> Insert mytable values (1,"'")
>>
>> Thanks.
>
Navigation:
[Reply to this message]
|