SqlCommand mycom = usercommon.createcommand();
         mycom.CommandText = "ModifyUserPwd";
         SqlParameter[] parm ={ new SqlParameter("@username", SqlDbType.VarChar, 50), new SqlParameter("@userpwd", SqlDbType.VarChar, 50), new SqlParameter("@newpwd", SqlDbType.VarChar, 50),new SqlParameter("@returnvalue",SqlDbType.Int) };

Pagination In SQL Server 2005

Pagination In SQL

If you've used other flavors of SQL (such as MySQL or PostgreSQL) and now you have switched over to TSQL (Microsoft SQL Server) you may have noticed that there is no native way of doing pagination. In some SQL versions, pagination was as easy as "SELECT * FROM 'myTable' LIMIT 0, 10" and that would pull out the first 10 records from your table. SQL Server 2005 introduced a beautiful new world of 'ranking functio