Tip Bank

Did you know you can start a job from the Query Analyzer? Here’s how you do it: exec msdb.dbo.sp_start_job @job_name = ‘My SQL job’

The WshShell Exec method can be used to launch a process. It returns an object that can be used to monitor execution and to access the stdin and stdout streams.

Sometimes, filenames may contain characters like “.” and file-extensions may not necessarily be always 3 characters long. This code provides a handy way to get file attributes in a foolproof

You may have noticed the auto completion feature in the edit controls in Microsoft’s file dialog boxes. You enter a few letters/words of the file path/file name, the edit control

You may have noticed that running a process from Java using Runtime.exec() sometimes hangs the process. This is true especially in those cases where the process runs in the background.

Sometimes, you need to retrieve a concatenated string from one column of a table without using the cursor. To do this, you can use string aggregation. Here’s how: Create &

Extracting parameters from a file using regular expressions can be a very effective and practical way of doing things. Suppose, for instance, that you need a logon script that maps

Most Java programmers close a connection with the database directly?without closing the ResultSet or Statement. For example, take a look at the following code snippet: try { Class.forName( “sun.jdbc.odbc.JdbcOdbcDriver” );

The sizeof() operator gives you the number of bytes required for storing an object. It also operates on a data type or a value. Another way of determining the size