April 29, 2000

Thanks to the SQL-DMO object model, it’s very easy to list all the available SQL Server 7.0 installations. For example, this code loads all the SQL Servers registered on the

Statistic functions – that is MAX, MIN, SUM, AVG, VAR, VARP, STDEV and STDEVP – don’t take Null values into account. Usually this isn’t a problem with the SUM function,

Sometimes Microsoft documentation can be, well lacking is a kind word, and one is reluctant to call tech support when they smoke your credit card first, and ask questions later.My

The SQL language offers a simple and effective way to quickly move all records from a table to another table with same field structure, that is same fields’ name, type

If you omit the ALL clause in an UNION statement, SQL Server must delete duplicate values, which in turn means that it has to sort the two sub-resultsets that have

The SELECT TOP N query always return exactly N records, and arbitrarily drops any record that have the same value as the last record in the group. To see what

The standard way to test whether two object variables point to the same object is through the Is operator, as in: If obj1 Is obj2 Then … However, when both

Using the SQL-DMO object model you can programmatically start, stop, pause, and continue the main SQL Server service. In the following code snippet the server is “MyServer”, and “sa” /

The DateSerial function has an interesting feature: it doesn’t raise errors when you pass it an invalid month or day number. Instead, it evaluates the date as if the arguments