Sql Server Single Quote. The single quote is the escape character in oracle, sql server, mysql, and postgresql. Can be a single quotation mark ( ' ), a left or right bracket ( [] ), a double quotation mark ( ), a left or right parenthesis ( () ), a greater than or less than sign ( >< ), a left or right brace ( {} ) or a backtick ( ` ).

If quote_character is not specified, brackets are used. Sql server (starting with 2008), azure sql database, azure sql data warehouse, parallel data warehouse. The simplest method to escape single quotes in sql is to use two single quotes.