Have we talked about REPLACE INTO? I'm still longing for the alternative syntax for INSERT.

INSERT INTO [###_120978_@@#@]

SET [ Key]='2863485278',

[ CustomerId]=78496,

[ ShippingAddressID]=12782,

[ TakenByID]=345,

[ OrderStarted]=GETUTCDATE()

majorbloodnock (5/10/2010)

---

A napkin? Wow; that's a bit upmarket. In the UK, we generally talk more in terms of a scribble or two on the back of a cigarette packet.

That said,...

I was asked if I was going to write my life story. No. But I thought about writing the amusing stories that have happened over the years. ...

There are three main component categories for a system:

"Hardware" - physical devices. How many programmers does it take to change a light bulb? None. That's a hardware...

One thing good about a progressive disability. I've "graduated" to Velcro on my shoes. They can't pull that...

What is NULL? I don't get it. 🙂

I agree with what has been said. Disk space is a big issue. Also if your restore fails part way through will SQL server have enough resources to...

Here is a case example:

Customer X has a couple dozen facilities. Product is transferred between facilities routinely. When transferring from A to B they "moved" the inventory from...

Yes you all have it right nut have not stated why.

In SQL a carriage return or two adds readability. We get into the habit of it and it's not...

Well you are right. A person under the influence (of what? fill in the blank) should be able to refuse work. I contend that it is your responsibility...

Well you...

OK stand by for the rant here.

One of the best things that happened at the dental company was that the development team worked for the support manager. It did...

You are going to just love this one! Try it like this:exec dbo.sp_msforeachtable 'select * from ?'

Note the lack of brackets. Go figure.

Given the set A which is a set of all sets that do not contain themselves as proper subsets, is set A in set A?

The infinite loop usually does not...

I would use this form:SELECT SomeThing

FROM wce_history

WHERE recordedtime >= DATEADD(MONTH, -2, DATEDIFF(DAY, 0, GETDATE()))

As others have pointed out there are issues with the time portion of datetime. ...