Topics

• Retrieve information about the database
• Join
• Common Table Expressions
• Last Inserted Identity

Examples

• Cross Join
• Determine a Windows Login's Permission Path
• Generate a table of dates using CTE
• SCOPE_IDENTITY()
• @@IDENTITY
• IDENT_CURRENT('tablename')