Examples: Using UDTs

These examples show the use of user-defined types (UDTs) in various situations.

Example: Comparisons between UDTs and constants
Suppose that you want to know which products had total sales of over US $100 000.00 in the U.S. in the month of July 1998.
Example: Casting between UDTs
Suppose that you want to define a user-defined function (UDF) that converts Canadian dollars to U.S. dollars.
Example: Comparisons involving UDTs
Suppose that you want to know which products had higher sales in the U.S. than in Canada and Germany for the month of March 2003.
Example: Sourced UDFs involving UDTs
Suppose that you have defined a sourced user-defined function (UDF) on the built-in SUM function to support SUM on Euros.
Example: Assignments involving UDTs
Suppose that you want to store the form that is filled out by a new applicant into the database.
Example: Assignments in dynamic SQL
If you want to store the application form using dynamic SQL, you can use parameter markers.
Example: Assignments involving different UDTs
Suppose that you have defined these sourced user-defined functions (UDFs) on the built-in SUM function to support SUM on U.S. and Canadian dollars.
Example: Using UDTs in UNION
Suppose that you want to provide your U.S. users with a query to show the sales of every product of your company.

Parent topic: User-defined distinct types