Nice one Tom.

Tom I need ask you one thing.

Is there any collation setting to affect the result of today's question ?

Nice question.

Thanks Lokesh for ur additional explaination...

Thanks for all your explaination guyz..

+1

Actually I'm unable to understand the comments and answers properly. Problem is with the word "CLOBBER".

But I'm aware of UPDATE behaviour and I know there won't be any issues in...

L' Eomot Inversé (1/31/2013)

---

Dineshbabu (1/31/2013)

---

Hi tom,

I don't think there will be a real need of chaining computed columns. Whatever experssion may...

Hi tom,

I don't think there will be a real need of chaining computed columns. Whatever experssion may be, we can incorporate...

Nice question and the thread shows few workaround for chaining computed column.

This is one of the many features which I never used in development.

demonfox (1/28/2013)

---

I don't think, it works like that ; BIT datatype stores only 1,0 or NULL ; (True/False goes as 1 /0). even inserting 7777777 or -1 gets inserted...

Thanks Tom for spending your most valuable time and preparing such a detailed article.

I need to go through it twice or thrice and to test with samples to understand it...

Thomas Abraham (1/25/2013)

---

Three other factors may be at work: laziness, spelling,and inertia.

1. ISNULL is shorter and easier to type.

2. COALESCE s harder to spell, with it's silent "C". As it...

Hugo Kornelis (1/25/2013)

---

No, my guess is that

(a) there are still many people who only use ISNULL (because that is what was used in the code they copied when they started...

manik123 (1/25/2013)

---

nice question... i am bit confusion about the point "The return type of COALESCE does depend on the data type precedence rules". can u explain any body?????

Manikandan.ps

Move fast as...

Easy One.. Thanks for the point.

I think few days back had a discussion about data type precedence of COALESCE.

Thanks Roddy and Tom..

Tom,

Can you explain actually what is happening in background while executing DBCC Checkident(). How identity values are maintained by sql server?

It will be very useful for...