devxlogo

Tip Bank

Tracking Elapsed Time

This C++ class tracks elapsed time. The mark() method is called at the point of interest, after which there are methods to retrieve the elapsed time between points, total time,

Display All the Subfolders Within a Folder Using VBscript

You can use VBscript’s Filesystemobject to list all the subfolders in a folder. Create a text file called showfolderlist.vbs and enter the following code: showfolderlist eg showfolderlist “c:windows” The Showfolderlist

Get All the Stored Procedure Names In One Shot

The following query will list all the stored procedure names available in the current database: SELECT name AS spnameFROM sysobjectsWHERE (xtype = ‘p’) AND (name NOT LIKE ‘dt%’)ORDER BY name