Toreador (12/8/2009)

---

sknox (12/4/2009)

---

Steve Eckhart (12/4/2009)

---

select cast(1.67574 as decimal(38,10)) = 1.675400000 which has precision 6 and scale 10, right?

and

select cast(10000 as decimal(38,10)) = 10000.0000000000 which has precision 1 and scale 10,...

Scott Coleman (12/7/2009)

---

The LEN() function ignores trailing spaces, comparing the strings doesn't actually ignore trailing spaces but it pads the shorter string with spaces. The answer's the same either...

When we build an application, or even work with a platform like SQL Server, what' s the right balance between simplicity and choice? I'm not sure, but I think that...

Technically speaking, the explanation for the answer is not correct. The explanation given is that SQL server ignores trailing spaces when comparing strings.

But in this example, SQL server isn't comparing...

wrong, and...

vk-kirov (12/4/2009)

---

...

Something about this can be found in BOL, topic "Precision, Scale, and Length (Transact-SQL)": http://technet.microsoft.com/en-us/library/ms190476.aspx

We have two numbers of type NUMERIC(38,10), so their precision = 38 and scale =...

I actually think Dan Linstedt had a good point, even if it was lost in the marketing-speke of the rest of his post. To wit: why do you have constraints...

duda (11/9/2009)

---

Nice one, Noticed that when you use your case statement as per below then you get the "Date is Null" results as you do not have your else statement.

SELEC[T]...

jacroberts (10/27/2009)

---

I can see that you can do this using SQL server but I fail to see any benefit to using SQL Server rather than wirting some code using a...

Well, this question does provide one good bit of information.

Based on the answer %s at the time of of writing, I estimate than somewhere between 66% and 74%* of...

Tom Garth (9/30/2009)

---

The question is specifically referring to SQL Server indexes. The Microsoft definition would...

Excellent article! I especially want to thank you for

I have not done a performance comparison of all the different methods. Each of the methods mentioned above has its own place....

Here are the two relevant statements from Books Online:

"Returns the value of the current timestamp data type for the current database." (in the definition)

"@@DBTS returns the last-used timestamp value of...

john.arnott (9/22/2009)

...

The important point here would seem to be that the environment from which a query is run can affect its output. I haven't tried embedding this sort...

Yes. That will catch the error as it happens. So you determined the value of @ERROR...