SQL database-<...>sql Programming--Simple learning

• data type : type of column
• variable definition : Declare variable name type name
  Variable name: Start with @
• assigning and taking values :
  Assignment: Set/select variable = value
  Value: Variable name
  Cases:
  DECLARE @a varchar (50)--Define variables
  Set @a = ' Hello world '-assigning values to variables
  --select @a = ' Hello world '-assigning values to variables
  Print @a--Value output
• operators : Arithmetic, relationships, logic, other
  Arithmetic: +-*/% no + +--
  Relationship:> < >= <= = <>! =
  Logic: And Or not
  Other: Between...and ... Exists like is not?:, nor%= + =-= ....
• Conditional Branches :
  An If expression
  Begin
  End
  Else
  Begin
  End
• Loop: Slightly
• Others: slightly

SQL database-<...>sql Programming--Simple learning