How to escape a single quote in SQL Server ?

You can escape a single quote in your T-SQL query in SQL Server by simply doubling them.

Here’s a simple example that demonstrates how the single quote ie escaped in SQL Server.

How to escape a single quote in SQL Server ?

DECLARE @temp_abundantcode TABLE (
    description VARCHAR(200)
)

INSERT INTO @temp_abundantcode VALUES ('This is abundantcode''s site.')

SELECT * FROM @temp_abundantcode