Paradroid888

--ADDING A COLUMN
IF NOT EXISTS(SELECT * FROM sys.columns WHERE Name = N'NewColumnName' AND Object_ID = Object_ID(N'ExistingTableName'))
BEGIN
	ALTER TABLE ExistingTableName
	ADD [NewColumnName] BIT
END

--DROPPING A COLUMN
IF EXISTS(SELECT * FROM sys.columns WHERE Name = N'NewColumnName' AND Object_ID = Object_ID(N'ExistingTableName'))
BEGIN

Paradroid888

/// <summary>
/// Generates a permalink slug for passed string
/// </summary>
/// <param name="phrase"></param>
/// <returns>clean slug string (ex. "some-cool-topic")</returns>
public static string GenerateSlug(this string phrase)
{
    var s = phrase.RemoveAccent().ToLower();
    s = Regex.Replace(s, @"[^a-z0-9\s-]", "");                      // remove invalid characters
    s = Regex.Replace(s, @"\s+", " ").Trim();                       // single space