Search code examples
sql-serverreserved-words

How to use sql reserve keyword in column name


How to use an SQL reserved keyword like the column name "desc" in a select statement?

select "desc" from tablename

Solution

  • Use brackets

    select [desc] from tablename