Entries categorized 'SQL' ↓

In my previous post , I showed some ways to query system objects in SQL Server. If you switch between MS SQL and other databases, that's the way to go, as the information schema views comply with ANSI SQL-92 standards. But there is another way to query information from MS SQL Server system catalogs it...

SQL Utility Scripts: Querying the System Catalog Part 2 - Catalog Views →

I have several SQL utility scripts (as well as classic ASP scripts, controls, utils, etc...) that I use regularly for everything from retrieving table listings to creating select, insert, update & delete stored procedures. Below are some of my favorite, daily use scripts. These can be used for quick...

SQL Utility Scripts: Querying the system catalog →