sql having quote max code example

Example: SQL Server escape single quote dynamic SQL

select 'that''s it'