For Wes to see

Moving Average in T-SQL

I don't have time to go through this now, but think I am will most likely like to know this sometime:  http://www.sqlservercentral.com/articles/Moving+Average/69389/

Post code here

Column Exists before creating

I do not know why, but I have trouble remembering how to check if a SQL Server Column exists before trying to add it.  Here it is:

IF NOT EXISTS (select * from syscolumns where id=object_id('[table_name]') and name='[column_name]')
    alter table [table_name] add [column_name] [column_definition>]

RegEx Strip of HTML

So, for some reason, I have real troubles with regular expressions.  Luckily, the magic of google usually gives me what I need.

But, here is something I tend to look up over and over.

From http://www.4guysfromrolla.com/webtech/042501-1.shtml:

Function stripHTML(strHTML)
'Strips the HTML tags from strHTML

  Dim objRegExp, strOutput
  Set objRegExp = New Regexp

  objRegExp.IgnoreCase = True
  objRegExp.Global = True
  objRegExp.Pattern = "<(.|\n)+?>"

  'Replace all HTML tag matches with the empty string
  strOutput = objRegExp.Replace(strHTML, "")
  
  'Replace all < and > with < and >
  strOutput = Replace(strOutput, "<", "<")
  strOutput = Replace(strOutput, ">", ">")
  
  stripHTML = strOutput    'Return the value of strOutput

  Set objRegExp = Nothing
End Function

There are some issues with this.  If you have text such as 50 < 10 and 9 > 100, your result is going to be:  50 100.

At some point, I came across this:

string _pattern = @"";

That solves the problem ... but seems to be limited quite a bit.

Here is a site that can test RegEx:  http://www.regular-expressions.info/javascriptexample.html

In case this site goes away, here is the code behind the widget:

function demoMatchClick() {
  var re = new RegExp(document.demoMatch.regex.value);
  if (document.demoMatch.subject.value.match(re)) {
    alert("Successful match");
  } else {
    alert("No match");
  }
}

function demoShowMatchClick() {
  var re = new RegExp(document.demoMatch.regex.value);
  var m = re.exec(document.demoMatch.subject.value);
  if (m == null) {
    alert("No match");
  } else {
    var s = "Match at position " + m.index + ":\n";
    for (i = 0; i < m.length; i++) {
      s = s + m[i] + "\n";
    }
    alert(s);
  }
}

function demoReplaceClick() {
  var re = new RegExp(document.demoMatch.regex.value, "g");
  document.demoMatch.result.value = 
    document.demoMatch.subject.value.replace(re, 
      document.demoMatch.replacement.value);
}

Here is another site to test regular expressions:
http://www.fileformat.info/tool/regex.htm

Fastest C# Case Insenstive String Replace

Copied straight from:  http://www.codeproject.com/KB/string/fastestcscaseinsstringrep.aspx
I am taking their word on the fact that it is the "fastest".

private static string ReplaceEx(string original, 
                    string pattern, string replacement)
{
    int count, position0, position1;
    count = position0 = position1 = 0;
    string upperString = original.ToUpper();
    string upperPattern = pattern.ToUpper();
    int inc = (original.Length/pattern.Length) * 
              (replacement.Length-pattern.Length);
    char [] chars = new char[original.Length + Math.Max(0, inc)];
    while( (position1 = upperString.IndexOf(upperPattern, 
                                      position0)) != -1 )
    {
        for ( int i=position0 ; i < position1 ; ++i )
            chars[count++] = original[i];
        for ( int i=0 ; i < replacement.Length ; ++i )
            chars[count++] = replacement[i];
        position0 = position1+pattern.Length;
    }
    if ( position0 == 0 ) return original;
    for ( int i=position0 ; i < original.Length ; ++i )
        chars[count++] = original[i];
    return new string(chars, 0, count);
}

Test Blog Post

Here I am testing the google-code-prettify technique which I learned about from Vivian's Tech Blog.

Here is some C#:

 private void buttonRestore_Click(object sender, EventArgs e)
 {
     string fileName = comboBoxFileName.Text;
     if (string.IsNullOrEmpty(fileName))
     {
         MessageBox.Show("Enter Path", "Please enter a path from which to list files",
             MessageBoxButtons.OK, MessageBoxIcon.Warning);
         return;
     }
     if (!backgroundWorkerRestore.IsBusy)
     {
         richTextBoxErrorMessages.Text = string.Empty;
         progressBar1.Visible = true;
         m_restoreMessage = string.Empty;
         buttonRestore.Enabled = false;
         backgroundWorkerRestore.RunWorkerAsync(fileName);
     }


     //richTextBoxErrorMessages.Text = "Database Restored";
 }

Here is some T-SQL:

SELECT * FROM ::fn_listExtendedProperty (N'AA_VERSION','user', 'dbo', 'table', N'tb_Auction', DEFAULT, DEFAULT)

It really works well.

How to post source code

So, you may have noticed that the previous post was pretty ugly.

Did a couple of quick searches on how to add code snippets to blogspot. Have not tried them out yet, but here are some:

• http://vivianningyang.blogspot.com/2009/05/how-to-post-source-code-in-blogspotcom.html
• http://code.google.com/p/google-code-prettify/
• http://www.htmlcodetutorial.com/linepar/_PRE.html
  

Eventually, I'll see how this works.