I'm an SMS administrator and I'm giving myself a crash course in SQL. This sounds like a really simple issue that some SQL guru can figure out in a flash.I want to make a report that lists all of ...

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

I'm doing this in a stored proc using SQL Server.<BR><BR>Basically, I'm executing 1 SELECT statement and if that returns any rows then I want to do a SELECT INTO #Temp With criteria A.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Do you want to find out how to avoid duplicates in the results of a SQL SELECT query? This article will show you how.

In addition, there isn’t a need for point-in-time or up-to-the-minute restores.For more information on recovery models review chapter 3, “Administering SQL Server 2005 Database Engine” on my ...