ziedkallel (8/5/2010)

---

CELKO (8/5/2010)

---

This makes no sense. A table has no ordering by definition. There is no concept of "first", "next", "up" or "down" in RDBMS. That is what you...

Hi

You can't use a check constraint to alter values - it can only check the values and generate an error if they are incorrect.

You can however use a trigger to...

Hi

I'd go with Jack's first option - i.e to use local variables, since the first thing you do in the stored procedure is overwrite the parameter values anyway. So that...

Duncan Pryde (8/5/2010)

---

Toreador (8/5/2010)

---

I've had a play with this on my development server, and the results seem a little curious. Apparently, I've used each of the collations Macedonian, Lithuanian_Classic, Korean_Wansung_Unicode,...

Toreador (8/5/2010)

---

I've had a play with this on my development server, and the results seem a little curious. Apparently, I've used each of the collations Macedonian, Lithuanian_Classic, Korean_Wansung_Unicode, Hindi, Azeri_Latin_90,...

Completely missed what the question was asking until after I'd answered it. Spent far too long looking at the ROUND() part of it, and not the integer division part.

I should...

Good question - it was obvious immediately what was being asked, which is always nice (I always have a problem with obscure/trick questions!).

Also, it's nice to be reminded of these...

Nice - one of those questions that makes you pause for a couple of seconds and think "Could there be an obscure use of this keyword that I'm not aware...

Thanks for the question. I'd not come across filtered indexes before, so it's only 7:30am and I've already learnt something new today. Can't ask for much more than that!

Duncan

jghali (7/21/2010)

---

We use them here for Total Calculations using UDF functions.

But since we are developping the application, we are beeing very careful that they are only used when there aren't...

Oh wait - there's the...

Frequently, and for general ease-of-use reasons...

jghali (7/21/2010)

---

I also would like to add.

The QoD is a great way to learn... I've learned so much answering and reading answers.

I would like to thank SQLServerCentral for this great...

A good question, apart from the ambiguity surrounding the resources question. Since it's calculated at runtime, it doesn't use any disk resources, and I can't see how having a select...

Nice question - I guessed that the collation was case insensitive (the default on any installation I've done), but got it wrong anyway, because I didn't spot that "Green" had...