Articles

SQLServerCentral Article

Introduction to ADO Part 4 - Combining It All

In three previous articles Andy has done a very basic introduction to the ADO connection, command, and recordset objects. In this wrap up article he talks about how to use the power of ADO client side filtering and disconnected recordsets, then adds some code which shows how to combine all the objects. ADO is not simple, but Andy has done a good job in limiting his dicussion to the things you REALLY need to know about ADO to get started.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2001-12-07

10,235 reads

External Article

Microsoft SQL Server 2000 Security

This document introduces the new security features of Microsoft SQL Server 2000. New features are outlined, and a detailed discussion is provided about how to best implement security in a Microsoft Windows 2000 domain environment. Source code examples are included for developers who want to implement the security model immediately.

2001-12-06

1,547 reads

SQLServerCentral Article

Worst Practices - Depending on the GUI

One of the strengths of SQL Server is its ease of management and administration over other systems. Oracle, DB2, even early versions of SQL Server required command line mastery to make many types of changes. But should you really be using the GUI for most of your tasks?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2001-12-04

6,230 reads

External Article

HOWTO: Run Singleton SELECT Queries in a Visual Basic Client

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.

2001-11-26

1,684 reads

Blogs

A Couple Quick GENERATE_SERIES Tests

By

I had someone reach out about generate_series() recently, saying they hadn’t realized this was...

How I passed the DP-700 Exam

By

I recently took and passed the DP-700 exam, which is required for the Microsoft...

Which approach to take: Build it, buy it, cloud it?

By

As a Consultant, I would typically answer with – it depends! Then a typical...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

How to Download and Restore AdventureWorks 2019 Database

By Noman072

Comments posted to this topic are about the item How to Download and Restore...

Tracking Table Sizes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Tracking Table Sizes

Visit the forum

Question of the Day

Counting Bits IV

What does this code return in SQL Server 2022+? 

select bit_count(2.4)
 

See possible answers