Previous Topic

Next Topic

Inhoudsopgave

Book Index

QUOTED_IDENTIFIER

Instead of using the setting QUOTED_IDENTIFIER = OFF, Isah will use the setting QUOTED_IDENTIFIER = ON.

You can only use features such as indexes on computed columns if QUOTED_IDENTIFIER = ON.

The QUOTED_IDENTIFIER setting is part of the code of stored procedures, functions, views, triggers, and tables. If you change the setting for an object, you need to recompile this database object.

If QUOTED_IDENTIFIER = OFF, you can put string constants in between double quotes. Do not use double quotes for identifiers when QUOTED_IDENTIFIER = OFF, for it will cause a compile time error.

If QUOTED_IDENTIFIER = ON, you can put an identifier in between double quotes. Do not use double quotes for strings when QUOTED_IDENTIFIER = ON, for it will cause an error.

As a column alias both strings and identifiers are allowed. For example:

Select PartCode as 'Artikelcode' from dbo.T_Part;

Select PartCode as [Artikelcode] from dbo.T_Part;

Select PartCode as "Artikelcode" from dbo.T_Part;