This article is tagged with:
Sql server escape single quote dynamic sql
and mysql
SQL Server escape single quote dynamic SQL
select 'that''s it'