Geeks With Blogs
Patrice Calve Life's short, have fun May 2009 Entries
Simple Sql script for finding a Guid/Uniqueidentifier in your database
So... You're trying to debug an application that is using a large (100> tables) database and for a reason or an other, you don't understand where this darn Id is coming from! Here's a simple Sql Script that browses your database for this darn Id... Just change the @Id = '' for the id you're looking for! declare @id as varchar(50) -- idToRemove.ToString() "" String select @id = '2eda82d8-9dcb-dd11-965a-00... set nocount on declare @template as varchar(5000) set @template = 'declare @id ......

Posted On Thursday, May 28, 2009 2:29 PM

Very simple Log() method in VB
A long time ago, I wrote a very simple log method. It was used to print the number of times a function/method was called. I just changed it a bit and added an optional dumpAll parameter for printing the whole results. It tracks 3 things: the name of the method, the number of times it was called, and stack level. Private Sub log(Optional ByVal dumpAll As Boolean = False) Static Dim h As New Generic.Dictionary(Of String, Integer)() If dumpAll Then For Each d As Generic.KeyValuePair(Of String, Integer) ......

Posted On Wednesday, May 6, 2009 9:47 AM

Copyright © Patrice Calvé | Powered by: