How to escape a single quote in SQL Server ?

AbundantCode 2 months ago in SQL Server 0

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
How to escape a single quote in SQL Server ?
Tags : , , , , 

Leave Your Comment