devxlogo

Tip Bank

Build Output Using the Ant <tstamp/> Task

When you execute , it generates the local ANT macros ${TSTAMP} and ${DSTAMP}. These are the time and date as numeric strings. They can then be used to dynamically generate

Dynamically Create a Sortable Column

Sometimes you need your resultset sorted a particular way and using the primary key doesn’t accomplish what you need. One way to get around this is to create a sortable

A SQL Split Function

This SQL function is similar to the VB split function. It takes a nvarchar delimeted list and delimeter and returns a table with the values split on delimeter. if exists

Funk Up Your Forms with Fading

I find this particularly useful in an MDI environment where you don’t want to keep switching forms to read information?just make the front form transparent to read the one behind,

Creating and Managing Global Variables

Sometimes, you can’t avoid declaring global variables in C++. However, should you prefer not to mix C++ with C code techniques, try the following: Create a global class and add

Get Details of the Aggregated Data

Say you want to get the latest processes running on Microsoft® SQL Server and their time, hostname, and the username. The following query retrieves this data: Use MasterSelect SysPro1.program_name,SysPro1.login_time,SysPro1.MemUsage,SysPro1.Hostname,SysPro1.Hostname,SysPro1.nt_domain,SysPro1.nt_usernameFrom sysprocesses

Register ActiveX Files Using the Mouse

Do you find yourself constantly registering and unregistering ActiveX .exe, .dll, .ocx, or .olb files? This script allows you to do so with just a mouse click. Here’s how to