Additional Articles

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

SQL Server 2000 Replication Chat Hosted by PASS Today

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!

2001-11-15

3,885 reads

Query to Display Trigger Status

Ever wanted to know whether your triggers are enabled or not? The ObjectProperty command allows you to select information about the status of objects in your database, returning 1 for True and 0 for False. The example below determines whether a single trigger is disabled. SELECT ObjectProperty(object_id('Trigger_Name'), 'ExecIsTriggerDisabled') There are a number of other useful […]

5 (1)

2001-10-28

1,025 reads

Blogs

SQL Prompt and SSMS 18.5

By

I downloaded SSMS 18.5, as there were a lot of fixes in here and...

Jupyter Book Challenges in ADS

By

I was excited to try the Jupyter Book feature in the March Azure Data...

Join me (virtually) in Adelaide!

By

I will be presenting a session to the Adelaide SQL Server User Group on...

Read the latest Blogs

Forums

Implementing Reporting Application Enhancements with No Downtime

By Imran Quadri Syed

Comments posted to this topic are about the item Implementing Reporting Application Enhancements with...

ADF Triggers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item ADF Triggers

In varchar column add numbers and show strings

By msbisqldeveloper

Below is the sample data create table temp (userid int , rid varchar(10), value...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

ADF Triggers

See possible answers