SQL 2005 for the SQL2K Developer Part 2

Continuing with his series on SQL Server 2005 from the developer's perspective, M. ChoirulAmri examines the ROW_NUMBER function and gives a few examples of how you can use this in your application.

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.