Application Development Guide


User-defined Distinct Types

  • Why Use Distinct Types?
  • Defining a Distinct Type
  • Resolving Unqualified Distinct Types
  • Examples of Using CREATE DISTINCT TYPE
  • Example: Money
  • Example: Job Application
  • Defining Tables with Distinct Types
  • Example: Sales
  • Example: Application Forms
  • Manipulating Distinct Types
  • Examples of Manipulating Distinct Types
  • Example: Comparisons Between Distinct Types and Constants
  • Example: Casting Between Distinct Types
  • Example: Comparisons Involving Distinct Types
  • Example: Sourced UDFs Involving Distinct Types
  • Example: Assignments Involving Distinct Types
  • Example: Assignments in Dynamic SQL
  • Example: Assignments Involving Different Distinct Types
  • Example: Use of Distinct Types in UNION

  • [ Top of Page | Previous Page | Next Page ]