how to escape ' in sql code example

Example 1: sql escape quote

DECLARE @my_table TABLE (
    [value] VARCHAR(200)
)

INSERT INTO @my_table VALUES ('hi, my name''s tim.')

SELECT * FROM @my_table

Example 2: sql escape &

SELECT 'Smith ' || chr(38) || ' Smith, since 1938.' FROM DUAL;