Ashok's Programming World

There are lots of ways of generating random strings in SQL Server. But instead of spending much time on finding solution to random password generation, here is an easy way to do that.

Cursors are great way to loop through records in SQL specialy when you need to deal with individual records from certain table.

Here is a example using cursor;

There will be case when you need to convert the values in Imperial system i.e. in feet and inches to the one in metric system. The conversion logic seems simple, but when it comes to SQL Server, it takes a bit complex.

Here is the function which can convert imperial unit of measurement to the metric system.

I have been searching for resetting the Auto increment value of ID Column in MSSQL Server 2008 and finally solved the problem. You can simply do the following in SQL.

The following line resets the Identity value for the ‘MyTable’ table to 0 so that the next record added starts at