Monthly Archives: December 2008

Remove Multiple Spaces

Posted on December 15, 2008 by bardev

I have a need to replace multiple space with a single space in varchar during a SQL statement.   On the web there were many solutions, but these two seemed to be the more simple ones.   DECLARE @strValue VARCHAR(MAX) SET @strValue = … Continue reading →

Posted in SQL Server | Leave a comment

Entity Framework

Posted on December 14, 2008 by bardev

  Resources:  ADO.NET Entity Framework http://msdn.microsoft.com/en-us/data/aa937723.aspx   Introducing ADO.NET Entity Framework(By Julia Lerman)  http://www.code-magazine.com/Article.aspx?quickid=0711051   MSDN Quickstart (Entity Framework) http://msdn.microsoft.com/en-us/library/bb399182.aspx   ADO.NET Entity Framework http://msdn.microsoft.com/en-us/library/bb399572.aspx   Additional MSDN Links The following topics enable you to learn more about the Entity Framework: … Continue reading →

Posted in Uncategorized | Leave a comment

Taskbar and Task Tray Tools

Posted on December 12, 2008 by bardev

For a good while I have been asking Microsoft for the ability to organize the Taskbar and also be able to minimize application to the Task Tray.  Over the past few day I decided that there must 3rd party tools … Continue reading →

Posted in Computers and Internet | Leave a comment

DOS – Batch Join SQL Files

Posted on December 12, 2008 by bardev

We have all of our SQL script in source control.   Whenever I update the database I have to go through each file and run it individually.  I wanted a way to be able to run all SQL scripts.  So, I … Continue reading →

Posted in Uncategorized | Leave a comment

Regular Expression Negative Lookahead

Posted on December 8, 2008 by bardev

I have a process that creates XML and inserts data within a element.  Some of the data that is inserted includes "&"s.  Since "&" can not be inserted into the XML without causing problems, I need a process to escape "&", but I do not want … Continue reading →

Posted in C# | Leave a comment