Tip Bank

DevX - Software Development Resource

Displaying Native SQL

Java Database Connectivity (JDBC) drivers sometimes perform conversions on Structured Query Language (SQL) statements that you execute before sending them to the database. It can be helpful for debugging purposes

DevX - Software Development Resource

Call Functions by Name

JavaScript has a powerful mechanism to create and execute code on the fly using the eval() statement. This statement takes a string as a parameter. This string is then run

DevX - Software Development Resource

Using Roles Properly

SQL Server 7 has taken great strides in improving its security model. Groups have been done away with and replaced by roles. The practical difference lies in the fact that

DevX - Software Development Resource

GetShortFileName – Convert a filename to 8.3 format

Private Declare Function GetShortPathName Lib “kernel32” Alias _ “GetShortPathNameA” (ByVal lpszLongPath As String, _ ByVal lpszShortPath As String, ByVal cchBuffer As Long) As Long’ Convert a long filename into the

DevX - Software Development Resource

And is faster the Mod

Use the And operator instead of Mod when the divisor is a number in the form 2^N. For instance, there are two methods to extract the least significant byte in