January 5, 2010

Use Comparison Operators in SQL to Remove/Return Columns with Null Values

When you use the comparison operators in SQL with the Where clause, you can remove the columns with null values. If you need the values with null too, then you need to use the appropriate ISNull function as follows: where IsNull(columnname, value) not like ‘comparisonValue’ Replace columnname with the correct

Displaying the Row Number in a SELECT Query with SQL Server 2005

Learn how to get row number in SQL. The 1998 tip “Displaying the Row Number in a SELECT Query” tells you to create a temp table to display the row numbers for a returned result set. That was an accepted solution for SQL Server 2000 and lesser versions. Now SQL