I'm not sure you are reading our replies, but this could help you:

CREATE TABLE dbo.Test

(

Column1 nvarchar(25) NULL,

Column2...

Glad to hear it. If you need more information on *how* it works, please see:

http://www.sqlservercentral.com/articles/APPLY/69953/

http://www.sqlservercentral.com/articles/APPLY/69954/

Koen Verbeeck (1/26/2012)

---

I also think 200 is still not correct, as you are using a variable length column, an additional 2 bytes are used, so the total should actually be...

sudhirnune (1/27/2012)

---

But the Query / Columns in All_Columns is meant to show the Size of the Column and not the Size,

I that case the Size is defined as 100, should...

Benefit of the doubt then.

Another possiblity for a right answer could have been:

SELECT

...

anandtr (1/27/2012)

---

i get different times from different zones like US, India etc. i need this to be converted to GMT keeping daylight saving into account. I am very new to...

Jeff Moden (1/26/2012)

---

Agreed... that's why I'm thinking it's no longer on the deprecation list but I really do remember seeing it there about a year ago. I'm just trying...

Unicode data requires 2 bytes per character.

See the documentation: Storage and Performance Effects...

One of the many issues with DATETIMEOFFSET is it doesn't handle things like daylight savings time.

CREATE TABLE dbo.Test

(

Date1 date NOT NULL,

Date2 AS DATEADD(MONTH, 1, Date1)

);

Many people choose to store dates and times in UTC (i.e. without a time zone). There is a good explanation of the technique here:

http://sqlblog.com/blogs/aaron_bertrand/archive/2012/01/10/t-sql-tuesday-26-second-chances.aspx

Jeff Moden (1/26/2012)

---

The deprecation that I remember was based on using table names instead of alias names for column callout in the SELECT list. Like this...

SELECT TableName.SomeColumnName

...

Just post a very small section of code that shows your technique. Are you using a WHILE...

ningaraju.n (1/24/2012)

---

Hi All,

I have stored procedure where i am building an xml by Concatenating the string

at different levels and at last converting string into xml.

Problem here is in the...

-- returns 1925

SELECT

[Days Since Previous Post] =

DATEDIFF(DAY, 'October 20, 2006', GETDATE());