Escape Character in SQL Server

You can escape quotation like this:

select 'it''s escaped'

result will be

it's escaped