Tag Archives: MS SQL

Reseeding a SQL Table

Sometimes you have tables that have an identity column (SQL Server) and whatever reason you need to reseed (reset) the identity column values. This may be a result of inserting …

Tags: | Posted under ASP .NET 4.0 | Leave a comment

SQL Server NULLIF Function

If you are like me when it comes to developing SQL solutions, you will inevitably use ISNULL function but did you know about NULLIF function. This function is almost the opposite …

Tags: , , , , , , | Posted under Programming/Coding | Leave a comment

Calculating Percent of Total in a SQL Select Statement

I am always amazed at how SQL server provides a lot of calculations and logic built right into a select statement. Most of the time (if you are like me) …

Tags: , , , , , , , , | Posted under Programming/Coding | Leave a comment