How to escape square brackets inside square brackets for field name

by

You can use the quotename function to see the proper escaping.

select quotename('Eggs[scrambled] or Bacon[fried]')

Returns

[Eggs[scrambled]] or Bacon[fried]]]

So all closing square brackets need to be doubled up.

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. How can I do an UPDATE statement with JOIN in SQL Server?
  3. How to update two tables in one statement in SQL Server 2005?
  4. Create a date from day month and year with T-SQL
  5. How important is the order of columns in indexes?
  6. How to return multiple values in one column (T-SQL)?
  7. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  8. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  9. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  10. Is it possible to select sql server data using column ordinal position
  11. SELECT FOR UPDATE with SQL Server
  12. How do I group on continuous ranges
  13. How can a LEFT OUTER JOIN return more records than exist in the left table?
  14. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  15. Dynamic SQL to generate column names?
  16. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  17. Column name or number of supplied values does not match table definition
  18. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  19. How to split string using delimiter char using T-SQL?
  20. How to find consecutive rows based on the value of a column?
  21. SQL server select distinct rows using most recent value only
  22. How do you copy a record in a SQL table but swap out the unique id of the new row?
  23. Eliminate and reduce overlapping date ranges
  24. Cumulative Total in MS Sql server [duplicate]
  25. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  26. Compare dates in T-SQL, ignoring the time part
  27. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  28. Is there a quick way to check if ANY column is NULL?
  29. Why do SQL Server Scalar-valued functions get slower?
  30. SQL query for parent-child chain

Leave a Comment