|
|
Posted by othellomy on 11/09/06 07:21
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]
|