I guess the bug has bitten me as well. After the very hype of Google +1 button, its time that they get some space in my blog as well.

Still in dilemma, if Facebook Like button should also be present? Well, time will only tell...

I ran into this strange situation where I wanted to get Trigger Definition(the SQL content) of a specific trigger from a database. The following SQL query can used to retrieve the trigger definition programitically.

SELECT 

DB_NAME() AS DataBaseName,

dbo.SysObjects.Name AS TriggerName,

dbo.sysComments.Text AS SqlContent

FROM 

dbo.SysObjects INNER JOIN 

dbo.sysComments ON 

dbo.SysObjects.ID = dbo.sysComments.ID

WHERE   

(dbo.SysObjects.xType = 'TR') 

AND 

dbo.SysObjects.Name LIKE 'YourTriggerName'

I started this blog with the goal to develop something small and focused, and allow me to play and get some first hand experience with developing and maintaining an end-to-end Web application. That has proven invaluable.
But over the period of time, a product's life comes to an end. And this is the time to say goodbye to my existing platform.
After doing quite some research I came to the conclusion to use DotNetBlogEngine.

Well, this one comes from after a discussion from one of threads on CodeProject. The following snippet shows how to toggle string casing in .NET:

public string ToggleCase(string input)
{
    string result = string.Empty;
    char[] inputArray = input.ToCharArray();
    foreach (char c in inputArray)
    {
        if (char.IsLower(c))
            result += Char.ToUpper(c);
        else
            result += Char.ToLower(c);
    }
    return result;
}

Ever wondered that how to get a comma (pipe or whatever) seperated result for a column in a table.
 
The following statement show a simple example you can take as a starting point.
 

Select (Stuff((Select ', ' + FName From Accounts FOR XML PATH('')),1,2,''))

Did you know that there is no way to branch the files recursively in Microsoft VSS? 
 
Here is a work around:
 
From Visual SourceSafe Explorer, go to View ->Search ->WildCard Search
 
Then search for Wildcard: * (a single asterisk) with Search in current project and all subprojects selected.
 
Then it will give you a list of ALL of your files in that project. Simply highlight them all and click on the Branch button.