Topics

• Keywords
• Properties
• Dates
• String Functions
• Trigger
• NULLs
• User Defined Table Types
• Table Valued Parameters

Examples

• Auto-implemented properties
• void
• if, if...else, if... else if
• Left
• Right
• Substring
• ASCII
• CharIndex
• Char
• Len
• Concat
• Lower
• Upper
• LTrim
• RTrim
• Unicode
• NChar
• Reverse
• PatIndex
• Space
• Replicate
• Replace
• String_Split
• Str
• Quotename
• Return just Date from a DateTime
• true, false
• Soundex
• Difference
• Format
• Types and classifications of Trigger
• String_escape
• ISNULL()
• Is null / Is not null
• DML Triggers
• creating a UDT with a single int column that is also a primary key
• Creating a UDT with multiple columns
• Creating a UDT with a unique constraint:
• Creating a UDT with a primary key and a column with a default value:
• Using a table valued parameter to insert multiple rows to a table