Suppose you have column ID in table T. Try the following:

Select ID, CAST(ID as Varbinary(255)) as Hex From T.

I find this to be sufficient in almost every case (and I...

Oops. clumsy sentence construction alert.

You wrote "As a result, I try to avoid wasting time and taking advantage of what I have when I can.".

You don't really want to avoid...

Some of us have to work with versions older than SS 2005, you know! DROP...CREATE is the only one that will work with ALL versions.

Hi Steve

This isn't about the content of this particular editorial or article, but about the way that the content is sometimes displayed.

My screen is displaying a width of 1680 pixels....

I fear the spell-checker has struck! You have "ellipse button" where you meant to say "ellipsis button"...

Better, I think, to stick to returning an offset that is an integer, but one that is in minutes rather than hours.

As I understand it, that's the real way that...

I see that you've defined @GMTOffset as an integer variable.

What happens if you're in Adelaide? Or Darwin? Or Caracas?