sql query single and double quote in the same query code example

Example 1: sql quote in string

/*adding single quote into the string in SQL*/
on P.SupplierID=S.SupplierID
where S.CompanyName in
('Tokyo Traders','Exotic Liquids','Grandma Kelly''s Homestead')

Example 2: SQL Server escape single quote dynamic SQL

select 'that''s it'