Difference between single and double quotes in SQL

718    Asked by ajithJayaraman in SQL Server , Asked on Jul 27, 2021

 Can someone tell me what is the difference between single and doubt quotes in SQL? Where we use SQL quotes?

Answered by Anna Ball

 Single SQL quotes are used to indicate the beginning and end of a string in SQL. Double quotes generally aren't used in SQL, but that can vary from database to database. Stick to using single quotes.You can use single quotes for a column alias — where you want the column name you reference in your application code to be something other than what the column is actually called in the database.



Your Answer

Interviews

Parent Categories