Pagination through SQL Script

Pagination of the records helps in faster and better display while generating a huge report or displaying hundreds of records on the screen. Performing the pagination through SQL script is some what tricky and an average developer finds it difficult to implement. Here I am suggesting the script to resolve the pagination problem.Use this script […]

Convert DateTime to HH:MM:SS

This simple select statemetn will convert a DateTime to HH:MM:SS.

You have to create some T-SQL that produces...

What does SEND do in SQL Server 2005?

What does REVERT do in SQL Server 2005?

HTML Email Using SQL

This would help you to send HTML email using T-SQL script, you just need to provide necessary parameters and you would have HTML email.

What result would you expect from this statement?...

Date Time Range or Calendar Generator

This function returns a formated calendar table. It came in handy a few times for me, so I thought it may be a good contribution. There would be a few better ways to create this function if date-part were a valid data type. It is a pretty straight-forward function. You may edit it if you […]

SQL Server 2005 for SQL2k Developer (Part 1)

There are many changes in SQL Server 2005, especially for the SQL Server developer. New options, features, and changes in the way you program. New author M. Choirul Amri brings us the first in a series on the changes from the point of the developer.

Update a table column with a sequence number v2.0

In response to Sachinvaishnav's search for a better way to insert a sequence number column in the same table, I bring you a cursor free Sql server 2005 example that utilizes the new ROW_NUMBER() OVER(ORDER BY) Function available in 2005