Using Underscores with wildcards in SQL queries

Yesterday, I wanted to do a wildcard query on table names that included an underscore. Since the underscore is considered a wildcard for a single character, I needed a way to 'Escape' the underscore. Fortunately there is a keyword that can be used in SQL.

Example: where fieldname like '%sp^_%' ESCAPE '^'

The Escape character now is the caret.

XMLRead and XMLWrite MSBuild Tasks

Hey,

I found what I was looking for...MSBuild Tasks for Reading and writing to a config file.

http://msbuildtasks.tigris.org/

MSBuild Equivalents to NAnt Tasks

Here is a pretty good link to equivalent tasks in MSBuild. I was looking for an equivalent to xmlpeak and xmlpoke. Guess I will have to write my own, unless someone else has one created.

http://channel9.msdn.com/wiki/default.aspx/MSBuild.EquivalentTasks

Creating Project and Item Templates - Visual Studio 2005

Folks,

It doesn't get much easier than this. I have created several templates in 2003, what a pain in the rear end.

Life is now simple,
http://msdn.microsoft.com/msdnmag/issues/06/01/CodeTemplates/default.aspx

Hanselminutes

Scott has really done a fine job in all of his Hanselminutes episodes. Great Content!!!!

I thought it is particularly cool that he mentions the ASP.Net 2.0 MVP Hacks book written by David Yack, the head of the Southern Colorado .Net User Group, which I will be presenting at next month.

Partial Classes - Adding a new method from the class designer

Yesterday during the Southern Colorado .Net User Group, a question came regarding adding methods to a particular partial class. This is how it is done.

1. Right-Click on the heading of the partial class in the class diagram and choose Properties.
2. Change the New Member Location property to the file you want to add to.
3. Add your method, property, etc. It will now go to the appropriate file location.