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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2001-12-07

10,296 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?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2001-12-04

6,237 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

Deploying an Updated Model with SQL Compare 16

By

In a previous post, I deployed a model to a database using SQL Compare...

Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022

By

Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...

Looking Back at the Redgate 2026 Company Kickoff

By

Last week I spent a few days in Cambridge, UK for the Redgate Company...

Read the latest Blogs

Forums

Adding and Dropping Columns II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding and Dropping Columns II

Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...

More Documentation is Needed

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Documentation is Needed

Visit the forum

Question of the Day

Adding and Dropping Columns II

I have this table in my SQL Server 2022 database: 

CREATE TABLE [dbo].[CityList]
(
[CityNameID] [int] NOT NULL IDENTITY(1, 1),
[CityName] [varchar] (30) ,
[Country2] [char] (3),
[stateprovince2] [char] (2),
[Country] [char] (3),
[stateprovince] [char]
) ON [PRIMARY]
GO
I decide to drop the stateprovince2 and country2 columns. What code should I use?

See possible answers