Rank the results of the following select statements...

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?