This article demonstrates how to retrieve a single record from SQL Server by using the IRow interface with a singleton SELECT. The main purpose for this technique is to avoid the overhead of creating a recordset when you are fetching a single record. Because no recordset is actually created, only one read-only ADODB.Record is returned. This is true even if the specified SELECT results in multiple records being returned if a normal ADODB.Recordset is used.

SQL Server 2000 Undocumented System Tables

by Alexander Chigrik

SQLServerCentral.com

Administration

Alexander Chigriks decodes some SQL Server 2000 Undocumented System Tables.

The Geek Test

by Steve Jones

SQLServerCentral.com

The Lighter Side

Are you a geek? Take this quiz.

Where should I save my DTS packages?

by Brian Knight

SQLServerCentral.com

One of the common questions you see in the newsgroups is where should you save your DTS packages. This article covers the most optimal way to save your packages as well as version controlling DTS.

SQL Server 2000 Replication Chat Hosted by PASS Today

by Additional Articles

PASS

Service Packs

SQL Server 2000 has better replication capabilities than ever before! Do you have questions about using Replication on SQL Server? Whether it be transactional or merge replication, you can not find a better group of guys to answer your questions. Right from the development team, Matt Hollingsworth and Dean Kalanquin, replication program manager and test lead respectively are setting aside this time to take on your most challenging replication questions!

ASP - Reaping the benefits of SQL 2000's FOR XML clause.

by Leon Platt

SQLServerCentral.com

In the several years that I have been programming ASP pages, I have seen countless methods of dynamically filling HTML drop down list boxes. Well, here's another method. This one uses sql 2000's new FOR XML EXPLICIT clause, and I really like the results.

Point-Counterpoint - Why you Should be Certified.

by Steve Jones

SQLServerCentral.com

Miscellaneous

In this view, Steve thinks that certifications are invaluable (especially in this economy).

Point-Counterpoint - Why You Should NOT Certity.

by Andy Warren

SQLServerCentral.com

Certifications

Andy Warren thinks certifications are worthless. That's opinion came after he obtained his MCDBA and MCSE certification. Find out why he thinks you should not be certified in this debate with Steve Jones.

Point-Counterpoint - Certification Debate

by Steve Jones

SQLServerCentral.com

Certifications

A new series on SQL Server Central - Two of our regular columnists take opposing looks at certification. In our first of the series, Steve Jones takes on Andy Warren in a certification debate.

THE PROGRAMMER'S QUICK GUIDE TO THE LANGUAGES

by Steve Jones

SQLServerCentral.com

The Lighter Side

A brief description of some well known, and not so well known programming languages. Have you worked with any of these?

HOWTO: Run Singleton SELECT Queries in a Visual Basic Client

SQL Server 2000 Undocumented System Tables

The Geek Test

Where should I save my DTS packages?

SQL Server 2000 Replication Chat Hosted by PASS Today

ASP - Reaping the benefits of SQL 2000's FOR XML clause.

Point-Counterpoint - Why you Should be Certified.

Point-Counterpoint - Why You Should NOT Certity.

Point-Counterpoint - Certification Debate

THE PROGRAMMER'S QUICK GUIDE TO THE LANGUAGES

Blogs

Learn about Modern Microsoft Apps in San Diego

How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps

A New Word: Attriage

Forums

Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393

Alamat Kontak Bank BCA KCP Pati Telp:08218154393

SSRS Reminded Me of the Time Microsoft Retired TMG

Question of the Day

BIT_COUNT II