September, 2007

  • Check to see if a string is empty

    There are several ways to check a string to see if it’s empty.  However, you should try to always use the following method.  It’s faster, and uses less resources.  This may seem like a minimal piece of code - but if you were checking strings...
  • Add a Column To An Existing Table

    If you need to add a column to an existing table with a default value:   ALTER TABLE YourTableName ADD YourColumnName varchar (50) DEFAULT ‘your default value’ WITH VALUES