Justin Cooney
Web Development Tips and Examples
Author: Justin Cooney
-
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…
-
Today I’ll review two useful queries that you can use to get information from SQL Server about what SQL statements are hitting one or more of your database tables. If you are interested in further T-SQL tips and tricks, please have a look through related articles I have written.
-
The idea of an Upsert was added in the SQL 2003 standard for databases and is implemented using a MERGE statement in both Oracle and SQL Server. So You Might Ask: What is an Upsert? An Upsert does pretty much does what it sounds like: it runs an update on a row where a condition…
Justin Cooney 