Get Rows where float column values is not a whole number

A way to find all those rows where a float column value is not a whole number. It is very simple by using the Floor function. Following scripts demonstrates the trick.

Posted Under: How-To, Query, SQL Server 2005, TSQL
This post was written by namwar on March 30, 2008 Comments (0)

Finding Total Space Used and Free Space in Each Data File of a database

Following code returns you the total file size of each data file in the database along with the space used in it.

Posted Under: How-To, SQL Server 2005, Shortcuts, Tips
This post was written by namwar on March 28, 2008 Comments (0)

Assigning incrementing values to integer column in a single statement without using identity field

This article explains a way of Assigning incrementing values to integer column in a single statement without using identity field

Posted Under: How-To, Query, TSQL
This post was written by namwar on March 27, 2008 Comments (0)