Graham Mulholland (9/8/2008)

---

Rhetorical question - Lotus Notes, as mentioned above, is an interesting example and I'm not sure of the exact history (only having used it in Windows (3.11 initially))...

I've used all kinds of software tools and, like most others,...

Usability is very important and a key factor in this is consistency with other products (even if they are not your products!).

<Gripe mode="on">

One of the reasons I hated to use...

Lynn Pettis (9/5/2008)

---

I must not fully understand INSERT triggers, but I was always under the impression that if nothing was inserted, an insert trigger WON'T fire. I have never...

To get < and > just use &lt; and &gt;

webrunner (8/26/2008)

---

Then there is the issue of which voting system is used to begin with. Even assuming complete data integrity, some have argued that certain voting systems are inherently unfair....

After looking at the reference in the asnwer (the ms-help: ref doesn't work for me) I tried the 'DBCC DBINFO()' statement and just got a message 'DBCC execution completed. If...

So now we have QotD questions which are Service Pack specific as well as version specific!

For all the production systems I access (all 2K5 SP1) this is a non-existent function...

Interesting timing since I'm taking next week off work to do some DIY in a bedroom.

Current task list:

Strip walls, fix plaster (skim), sand woodwork, paint woodwork, lay laminate floor (including...

Luc Philie (7/3/2008)

---

Declare @d smalldatetime

set @d = '1957/7/5'

Select DATEDIFF(yy, @d, GETDATE()) -

CASE WHEN

DATEPART(m, @d) < DATEPART(m, GETDATE())

OR (

DATEPART(m, @d) = DATEPART(m, GETDATE())

AND

DATEPART(d, @d) <= DATEPART(d, GETDATE())

) THEN...

GilaMonster (6/30/2008)

---

It's when someone has the attitude 'I know Everything' but knows nothing that I have a problem. If someone rates themselves say a 3/5 for SQL I won't be...

The computer doesn't say anything. The question setter says "You are wrong" 😀

In my case, I didn't...

I usually put the latest CU on a development system, so if we...

brewmanz (6/24/2008)

---

I don't understand what you mean. My posting, 2 days...

km.abbasi (6/24/2008)

---

I am 100% sure that this question is wrong , there are two mistakes

1) value1, value2 and so on are in lower case and in search Value1 is initiated...