KMA Training Forums

Proceeding today's class here are a few SQL identifiers that we all should be come familiar with

• Quoted identifiers are delimited by double quotation marks (“):

  SELECT * FROM "Blanks in Table Name"

    

• Bracketed identifiers are delimited by square brackets ([ ]):

  SELECT * FROM [Blanks In Table Name]

• ~ (tilde)	- (hyphen)
  ! (exclamation mark)	{ (left curly brace)
  % (percent)	} (right curly brace)
  ^ (caret)	‘ (apostrophe)
  & (ampersand)	. (period)
  ( (left parenthesis)	\ (backslash)
  ) (right parenthesis)	` (accent grave)

 Multi-commenting

/* This is the best form of multi-line

commenting and the way in which it should be done*/

and

-- This is single line commenting