How to use sql reserve keyword in column name

sql-server reserved-words
saun4frsh picture saun4frsh · Oct 2, 2013 · Viewed 8.5k times · Source

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

select "desc" from tablename

Answer

juergen d picture juergen d · Oct 2, 2013

Use brackets

select [desc] from tablename

Related questions

SQL error: Incorrect syntax near the keyword 'User'

I am using SQL to insert data to SQL Database file using C# as follows. String cs = System.Configuration.ConfigurationManager.ConnectionStrings["connection1"].ConnectionString; SqlConnection conn = new SqlConnection(cs); String sql = "INSERT INTO User (login, password, status) " + "VALUES (@login, @password, @status)"; …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More