November 25, 2003

Find and Replace a String in a Table

The folowing stored procedure will find and replace a string in a table: CREATE PROCEDURE [dbo].[sp_st_FindANDReplaceString]@Tablename varchar(20),@FieldName varchar(20),@FindString varchar(30),@RepalceString varchar(30)ASdeclare @sqlstring varchar(8000)Select @sqlstring = “Update ” + @Tablename + “

A Fabricated ADO Recordset

A disconnected recordset is a recordset which does not hold an active connection. A fabricated recordset can be viewed as a variation of a disconnected recordset. The variation in the

Get the Current Host Info

This program prints out the name and the address (in both textual and numerical forms) of the machine on which its run, using the InetAddress singleton. import*;public class CurrentHost

Serialize Data Using a PropertyBag

You can serialize your data quickly by placing it into a PropertyBag object, then reading the PropertyBags Contents property. This property is really a Byte array that is a serial

Manage Errors with Sparse Line Numbering

You might have used line numbering to track error locations, but this technique can be a pain (and ugly) to use for every line. Sparse line numbers help you locate