John Marshall - Customer Fulfilment Manager
John is our customer fulfilment manager and oversees the needs of our clients.
Sep 2007
11
The standard way to to it is do double the string delimiter:
insert mytable values (3, '''', getdate())
Standard SQL only recognizes ' as a string delimiter. " is used to delimiter
identifiers with "funny" characters in them, like space. (Although with SQL
Server you normally use [] in this case.)