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
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
When you plan your queries, you should avoid the use of wildcard keyword * – which means “retrieve any field” – mainly because it may decrease performances, since the engine
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
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
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
Through its java.util.zip package, Java provides you with an easy mechanism to compress/decompress files. Here is a method called zipDir, that shows how to recursively zip a directory structure. Note
This is a Class to perform rotr and rotl as known in standard C implementations and a rotate with carry implementation. The technique used is to determine which bits within