Browse by Tags

MS SQL Check If Column Exists

The following SQL script checks if a certain column exists in a certain table, then prints some text to the output window. I'm getting into the best practice habit of creating SQL scripts that can be re-run without any errors and this is useful in checking to see if a column already exists before...

Posted to Matt Williamson's Blog (Weblog) by Matt Williamson on 07-08-2009
SQL Replace Function on NTEXT Data

Today I've made some changes to my hosted environment. I've decided to enforce my websites URL as always 'http://www.bunkerhollow.com' instead of 'http://bunkerhollow.com'. This will keep the URL the same whether I'm inside or outside of my network, while retaining search...

Posted to Matt Williamson's Blog (Weblog) by Matt Williamson on 06-07-2009
MS SQL Loop Through Table Scripts

At some point you may want to loop through every row in a table and perform operations based on the fields in each row. After a bit of investigation, I've found the 2 most common ways of doing it. Loop Through All Rows of a Table Using a Counter This method requires that the primary key is an integer...

Posted to Matt Williamson's Blog (Weblog) by Matt Williamson on 03-10-2009

Page 1 of 1 (3 items)

Bunker Hollow