Archives for February 2008

Sql Date Time formats.

Fromhttp://lists.evolt.org/archive/Week-of-Mon-20020617/115646.html withoutcentury (yy) withcentury(yyyy) standard outputformat – 0 or 100 (*) default mon dd yyyy hh:miAM (or PM) 1 101 USA mm/dd/yy 2 102 ANSI yy.mm.dd 3 103 British/French dd/mm/yy 4 104 German dd.mm.yy 5 105 Italian dd-mm-yy 6 106 – dd mon yy 7 107 – mon dd, yy 8 108 – hh:mm:ss – [...]

Run Command Most Recently Used List Storage

At least for Windows XP, this list is stored in the registry: My Computer\HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\RunMRU It looks like there are values \a through \z off of RunMRU, plus \(Default) and \MRUList. There is string value in MRUList: e.g., “nkvlsawbhczeyoijfugrtdxpmq”, which determines the ordering of MRUList entries.

Miscellaneous Excel tricks that I needed today.

How to hide gridlines on an Excel Worksheet. Select a Worksheet.Select Tools->Options…On the [View] tab, un-check Gridlines under the Window Options section. Row and column headers, scroll bars, and sheet tabs are also hideable through this tab. How to Split and Freeze Panes Freeze panes makes very nice title rows (the bottom pane does not [...]

ILASM and ILDASM (.NET "Assembler")

Reverse Engineering To Learn .NET Better Accessible via command line using:Start->Microsoft Visual Studio 2005->Visual Studio Tools->Visual Studio 2005 Command Prompt