Passing a Variable to an IN List
Every once in a while there is a need to do something like this: SELECT person_id, person_nameFROM MyUsersWHERE person_id IN (@search_list); And @search_list contains some form of a delimited list. However, this is not a supported syntax and will fail. Here is one solution to this problem: — Create the test tableCREATE TABLE MyUsers ( person_id […]
SQL Server 2005 Service Pack 2
The long awaited SQL Server 2005 SP2 is released! This is important for a few reasons, not the least of which that Vista requires SP2 to run SQL Server. It is an all inclusive service pack, which means it includes everything from service pack 1. The installation requires 1.9 GB of disk space available to […]
SQL Server 2005 Compact Edition
While using SQL Server Compact Edition for mobile applications makes perfect sense, using it for regular desktop applications may not be the best choice. Here is a summary of pros and cons of using the Compact Edition with desktop applications. Pros: – Very small footprint (only 7-8 DLLs needed, no services installed, runs as in-process […]
Convert Tree Structure From Nested Set Into Adjacency List
Tree structures are often represented in nested set model or adjacency list model. In the nested set model each node has a left and right, where the root will always have a 1 in its left column and twice the number of nodes in its right column. On the other side the adjacency list model […]
DST 2007 and SQL Server
Beginning in 2007, daylight saving time (DST) will be extended in the United States. DST will start three weeks earlier on March 11, 2007, and end one week later on November 4, 2007. This results in a new DST period that is four weeks longer than previously observed. How that does affect SQL Server users? […]
Developing & deploying custom user controls in WPF
In WPF the development and deployment of custom user controls is similar to the development and deployment of user controls in ASP.NET. Let say that you have made a user control named MyUserCtrl1 in your main application project. In order to use this control in a Window you must first declare a namespace for it. […]