![]() SELECT "sometext" AS Value - FAIL because “sometext” is not a literal SET QUOTED_IDENTIFIER ONĬREATE TABLE "SELECT" ("TABLE" int ) - SUCCESS And any character set that is defined in the Single Quotes ‘’ is treated as a Literal. ![]() When it is set to ON any character set that is defined in the double quotes “” is treated as a T-SQL Identifier (Table Name, Proc Name, Column Name….etc) and the T-SQL rules for naming identifiers will not be applicable to it. ![]() It specifies how SQL Server treats the data that is defined in Single Quotes and Double Quotes. Lets first understand what they exactly mean to SQL Server and then we will move on to why they are special. Most developers explicitly set these options while creating Stored Procedures, Triggers and User Defined Functions but many are unclear on why we need to explicitly SET them? And why they are special compared to other options?īelow is the typical usage of these options. These are the two widely used SET options in SQL Server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |