Topics

• Retrieve information about the database
• Retrieve Information about your Instance
• Stored Procedures
• COALESCE
• Drop Keyword

Examples

• Get information on current sessions and query executions
• Retrieve Tables Containing Known Column
• Search and Return All Tables and Columns Containing a Specified Column Value
• Creating and executing a basic stored procedure
• Using COALESCE to Build Comma-Delimited String
• Coalesce basic Example