Sql escape quote

This article is tagged with: Sql escape quote and mysql

sql escape quote

DECLARE @my_table TABLE (
[value] VARCHAR(200)
)
INSERT INTO @my_table VALUES ('hi, my name''s tim.')
SELECT * FROM @my_table

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')

This article is tagged with: Sql escape quote and mysql