Articles → SQL SERVER → Use Keywords As Identifiers In SQL Server

Use Keywords As Identifiers In SQL Server






Software Requirement





Scenario





Error When Using Keyword As An Identifier




CaseCommandResult On Execution
Case 1create database databaseMsg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'database'.
Case 2create database 'database'Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'database'.
Case 3create database "database"Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'database'.



"Set Quoted_Identifier On"






set quoted_identifier on



Output


Picture showing how the keywords can be used as identifier in SQL server



Posted By  -  Karan Gupta
 
Posted On  -  Tuesday, March 12, 2013

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250