Skip to content
Tech Shizz Logo

An Engineers Blog

  • TechShizz
  • blog

SQL: What is a quoted Identifier?

Posted on February 23, 2021 By rich No Comments on SQL: What is a quoted Identifier?

Enabling a quoted Identifier allows you to use a word not usually allowd by SQL when placed inside inverted commas. Here is an example.

THIS WILL FAIL, because SELECT is not allowed.

CREATE TABLE SELECT
(
    SelectID int NOT NULL,
)
GO

THIS WILL WORK as quoted identifiers are turned on allowing the use of the term select.

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE “SELECT”
(
    SelectID int NOT NULL,
)

Post navigation

❮ Previous Post: SQL: Information on SQL Server Editions and Features
Next Post: SQL: Create a Database ❯

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Subscribe to our newsletter!

Recent Posts

  • How to implement a lightning-fast ransomware playbook
  • How to achieve defence in depth in your business
  • How to implement a SecOps team phishing response plan
  • How to block an Office 365 Sign-in correctly
  • Microsoft finally patched serious Exchange 0-day over a month old!

Recent Comments

    Archives

    • November 2022
    • July 2021
    • March 2021
    • February 2021

    Categories

    • Cyber Security
    • Uncategorized

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Copyright © 2023 .

    Theme: Oceanly News Dark by ScriptsTown