In 2008, there's no need to use the undocumented and unsupported fn_varbintohexstr any more.

Simply CONVERT directly to (N)VARCHAR using the new style parameter.

Style 1 preserves the 0x header, style 2...

There are many methods available:

How to identify your SQL Server version and edition

SERVERPROPERTY

@@VERSION

xp_msver

It depends on what the two instances are for - it's really impossible to say one way or the other without knowing more about your situation.

In general, though, if the...

RBarryYoung (4/10/2010)

---

Someone please tell me that this is not how Paul knocked out 3000 points in one month. I had ***-umed he was just racking up all of the...

While revisiting the Numbers table solution, I discovered that the following code creates a table from 20 names in 6 seconds on my old laptop:

USE tempdb;

GO

IF ...

I tend to agree - and I have no idea why constraints are schema-scoped objects.

There should have been 26. Unless I missed one, or the size of the alphabet changed mid-way through...?

A table variable is scoped to a batch - as it says...

Tom.Thomson (4/9/2010)

---

First, the statement "I'm sure none of you would store dates as characters, but it does happen." is all very well, but if you are recording for example dates...

No. You failed to answer correctly because you made an incorrect assumption, based on incomplete knowledge. Attempting to wriggle and back-track...

zark

yonder

XACT_ABORT

Wellington

verbose