Escape Character in SQL Server

by

You can escape quotation like this:

select 'it''s escaped'

result will be

it's escaped

More Related Contents:

  1. How can I escape square brackets in a LIKE clause?
  2. How to get the last row from a table in SQL Server?
  3. Alias name is same as column name [closed]
  4. LocalDB deployment on client PC
  5. Understanding PIVOT function in T-SQL
  6. The order of a SQL Select statement without Order By clause
  7. Using RegEx in SQL Server
  8. What is the best way to auto-generate INSERT statements for a SQL Server table?
  9. Storing a file in a database as opposed to the file system?
  10. SQL Server named instance with Visual Studio 2017 Installer project
  11. How do you count the number of occurrences of a certain substring in a SQL varchar?
  12. Why is it considered bad practice to use cursors in SQL Server?
  13. Import Excel spreadsheet columns into SQL Server database
  14. CAST and IsNumeric
  15. Find index of last occurrence of a sub-string using T-SQL
  16. Hidden Features of SQL Server
  17. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  18. SQL Server 2008 Empty String vs. Space
  19. How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
  20. SQL Query to find the last day of the month
  21. SQL Server, convert a named instance to default instance?
  22. How to drop column with constraint?
  23. How to specify a port number in SQL Server connection string?
  24. Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()
  25. SQL Server 2008 Vertical data to Horizontal
  26. What are some ways of accessing Microsoft SQL Server from Linux?
  27. LPAD in SQL Server 2008
  28. Conditional JOIN Statement SQL Server
  29. How do you deal with blank spaces in column names in SQL Server?
  30. ODBC Call Failed with stored procedure – Pass through query

Leave a Comment