bkubicek (5/25/2010)

---

Hugo,

It is the precision of the variable you are putting the value into that matter. @min-2 is a numeric(10,4), so you will get your four decimal places using...

If numeric(3,1) works, then 60.0 is as good as any of the other options....

marklegosz (5/25/2010)

---

The integer division thing in general for me is often one of those "so simple you missed it situations". I'd be interested in what is considered best practice in...

:laugh: I had not even seen that!

(note to self: in future, check question category before answering!)

malleswarareddy_m (5/24/2010)

---

hi ,

like operator will search for _ only.and return any characters. then it does not return any rows.because i worked many times using like operator.but if we use '%_%'...

Great question!

I did consider collations before replying, but only thinking about the possibility of a collation where the space character would fall somewhere between 'A' and 'Z'. And after discarding...

+1 on all points made by...

bkubicek (5/24/2010)

---

Hugo,

To do what you suggest would cause this Question to be too easy. Perhaps you are fortunate enough to NOT have inherited some poor code from previous employees....

I'll admit this right away - I cheated; I used copy and paste to have SSMS work out the answer for me.

I don't feel bad about it either. I know...

Toreador (5/21/2010)

---

Not quite the same, but I've now done exactly the above and get the same error.

Note - the error appears in a popup window. I've a feeling that depending...

Toreador (5/21/2010)

---

Nope, doesn't work for...

While I mostly agree with the sentiment expressed in the editorial, there is one place where I don't. Where, in fact, I'd even reverse the statement:

"There really is little justification...

natalie.ignatieva (5/20/2010)

---

The correct answer is "XML segment, with the integrated parser marking most values illegal, but IE can open this segment surrounded by root element ", but my IE gives...

honza.mf (5/20/2010)

---

Hugo Kornelis (5/20/2010)

---

@honza.mf: Great question! I never work with XML myself so this was a good learning opportunity.

The only thing I like less about the question was that it...

da-zero (5/20/2010)

---

honza.mf (5/19/2010)

---

Maddy...! (5/19/2010)

---

hello frnds....

wht ever it may be in order to run completely a block of t-sql code it should be syntax error free

i think there is...