Transactions within Microsoft SQL Server 2005 and greater using Try and Catch. [More]

An example that uses a subquery in a SELECT statement. [More]

MS SQL Server is case insensitive by default To make a column case sensitive for a password field is a straight forward process you can do within Visual Studio [More]

Use UNION ALL and a Sub Query with T-SQL to set a default value in a dynamic asp:DropDownlist. [More]

One of my recent projects had a requirement which called for an upcoming events menu with a DHTML popup for each entry that had a short description of the event. Since I didn't need ordering or paging I decided to display the content via an asp:DataList enclosed within a user control as in figur... [More]