Justin Cooney

Web Development Tips and Examples

recent posts

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

Category: SQL Server 7

  • T-SQL to Enforce Proper Case Capitalization

    This handy-dandy T-SQL query will take any input string and capitalize the start of each word within the string. It will also enforce proper use of lower-case throughout the string without affecting query performance too severely. This query assumes that you are working with titles, user names, or place names where you want to make…

  • .NET – Write A File to Disk from your Database

    In this example I will review and give examples in C# and VB.NET how to get and save a file stored in an Image datatype in a SQL Server table. Here is a link to a list of other articles I have written about using .NET with SQL Server.

  • ASP.NET – Handling Null Return Values from the Database using IsDBNull

    If you are retrieving or adding values from and to your database then you will know the difficulties that can be caused by NULL values. The notorious InvalidCastException is one example of receiving a NULL value from your database into an ASP.NET object that doesn’t know what to do with database NULL values. Here’s typical example…