Feeds:
Posts
Comments

Archive for the ‘SQL Server Queries’ Category

Multiple Optional Search Criteria in SQL Server WHERE Clause

Posted in Sql Filter Criteria, SQL Server Queries, Uncategorized, tagged , , , , , on July 29, 2010 | 1 Comment »

Today I was reading in Joseph Sack’s book SQL Server 2008 Transact-SQL Recipes and discovered a jewel of a tip.  The jewel is located on page 275. “So what is the jewel?”, you are asking.  Well I am glad you asked.  Let’s say you have 30 different criteria for which to search for a particular [...]

Read Full Post »

Useful SQL Server Queries for Getting to Know a Database

Posted in SQL Server Queries, tagged , , , on September 16, 2008 | Leave a Comment »

I thought I would list a few queries here that would help you get to know an unfamiliar SQL Server instance and its databases. Listing All Databases for a SQL Server Instance USE Master GO SELECT * FROM sys.Databases GO   Listing all Tables for a Given Database  USE yourDBName GO SELECT * FROM sys.tables GO [...]

Read Full Post »

Follow

Get every new post delivered to your Inbox.