Sql Server 2005

I used to create temporary tables and subqueries to add a row number to every row in the result set. But somedays ago, I came across to the Row_Number() function provided in Sql Server, which simply constructs the row number column on the fly as part of the query. But a question might have arosed in your mind, What is the use of adding a Row_Number, when we have serial number associated with every row. There are several situation, where we need to query against the row number.(we can't query against a serial number)

I want to reset an identity coloumn in SqlServer. I am using

Delete from "TableName".

It is deleteing all data in the table but it is not resetting my Identity value.

I have tried Truncate Table , But I will not be able to restore my data back in case of truncate.

I need a method to delete all rows from the table and simultaneosly reset the identity value.

What is the difference between Stored Procedures and User Defined Functions in sqlserver.

Understanding Indexes

Indexes speed up the querying process by providing filtered access to rows in the data tables (just like book’s index) if they are used efficiently.

Indexes are created on columns in tables or views.