On my SQL 2008 server (using the Master database so no question of compatibility level) this fails with the previously mentioneed "GetBytes function" error.

use master

DECLARE @Date AS DATE=GETDATE()

SELECT @Date...

I'd like to seee the explanation expanded to explain that select convert(money,'0,.0') would work, and that is why isNumeric is returning true (i.e. that isnumeric is ignoring the comma because...

I hvaen't done so yet, but it's likely that I...

Mark D Powell (6/11/2009)

---

But the question was on Unicode not UCS-2! SQL Server does not actually support Unicode; it supports UCS-2 which is a limited subset of the Unicode...

James Rochez (6/11/2009)

---

AndyK (6/11/2009)

---

Two bytes per character may be how Unicode is implemented in SQL Server - but code elements of one through four bytes are used in various definitions...

Tao Klerks (6/8/2009)

---

john.arnott (6/8/2009)

Hmm... could this be why so many people post to the thread without (apparently) reading anything that has gone before? Could/should the site implement a "negative points...

-snip-

Notice datalength is the same for a variable, table variable,...

DBA Cabuloso (6/5/2009)

---

The question is about the space allocated to a variable like

DECLARE @onechar as varchar(1)

DECLARE @onechar as char(1)

not to a table.

And the space allocated to both is equal.

Pay attention...

Jack Corbett (4/27/2009)

---

john.moreno (4/27/2009)

---

This example is based on actual SQL code written by a developer (who shall remain anonymous) who was exceptionally proud to have figured out this entire routine...

This example is based on actual SQL code written by a developer (who shall remain anonymous) who was exceptionally proud to have figured out this entire routine on his own....

That describes the physical storage. But the language specification...

The answer is debatable because the answer isn't guaranteed. It would not be a bug in SQL Server for it...