Justin Cooney

Web Development Tips and Examples

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 2000

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

2013-05-15

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…
T-SQL – Replace Multiple Extra Whitespaces in a String with One Whitespace

2013-05-04

In this article I will review three easy methods that can be used to replace extra spaces between words in a string. Note that if you want to remove extra spaces from the start and end of your string you will still need to encapsulate the output of the routines within the standard LTrim /…
T-SQL – Search a Database for all Table Columns with a Text Value

2013-01-03

There are times when it comes in handy to be able to query all columns of all of the tables in a database for a particular text match. For example: if you have just taken over a project with a large database and are trying to find where values from the UI are coming from,…

recent posts

about

Category: SQL Server 2000

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

T-SQL – Replace Multiple Extra Whitespaces in a String with One Whitespace

T-SQL – Search a Database for all Table Columns with a Text Value