In the REPEATABLE READ isolation level, what phenomena...

UDF: Parse a delimited list of paramters

After replying to a post today I thought I'd share this with all.This is a user defined function that I use to return a table of parameters passed in a parameter string. Function UsageSelect * From dbo.fnParseParamString ([@ParamString='Delimited String of parmaters'],[@Delimeter='Delimiting Character'])Lets say you are concatenating a list of form data from a web page […]

Which of the following datatypes can be represented...

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.