CASTING Binary to BIGINT

Arithmetic

Datetime Formats

This stored procedure will show all possible datetime formats when used with the style argument in the CONVERT() function. It also shows sample output from the date part arguments.

What will convert return?

Casting question

Predict the outcome of the SQL statements

Predict the outcome of the SQL statements

Convert seconds to a timestring

This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'

RE: Is XML the Answer?

We use XML all over the place not because we need it, nor because it's better than other ways of retrieving data but because 3 years ago it was hot and our developers wanted it on their CVs. Just a cynical afterthought.

RE: Question assigning IDENTITY values

Do you have any insights as to where I might be able to read up on programing such a task?  There is quiet a few records and would be a pain to go through and assign each number a unique value.