Not entirely true. (Try '130' + 1 + '120' => 251)

If you see the...

A good question (which I got wrong :(), but I think that these references better explain what's happening:

http://msdn.microsoft.com/en-us/library/ms190276 (operator precedence)

http://msdn.microsoft.com/en-us/library/ms190309 (data type precedence)

When two operators have the same precedence (as...

You almost certainly don't need a loop (and it would probably be a very bad idea to do so). I suspect that something like this will do the trick:

INSERT...

Am I the only one who saw the title of this article and thought it was referring to the Katy Perry song - "I killed a PID and I liked...

I'm curious as to what circumstances you would plan on using this script - the hard part is usually getting developers to include comments in the first place; I can't...

Yep - don't know where I got that from. I guess it just looks like the sort of thing that's come from a file...

If it can be made to fit into your workflow, my inclination would be to create some kind of script to preprocess the file into this:

id , name , dummy1...

I have to admit I only got it right because I've never seen a Setup Event Log before. Is this something new in Windows Server 2008? - it's not...

Toreador (5/8/2012)

---

To those who said the answer was easy - is this because you know how SQL handles implicit conversions of this sort, or because you ran the code? I...

Do you have more than one version of SQL installed? I've seen SSIS getting a bit confused about file locations if there are multiple versions.

Is 100\DTS\Binn on your path?...

SQLRNNR (3/16/2012)

---

happycat59 (3/15/2012)

---

Whilst it might take a while, eventually you will get an error when you run out of disk space. So, I kinda think that the correct answer...

I got this one wrong despite knowing what the "correct" answer was, because I elected to treat the word unlimited literally. You will get an error unless you've got...

If anyone finds themselves in this situation (I know I have), there's a fairly easy way to still get into SSMS (assuming you have access to another database on the...

Not unlimited - limited by the size of the underwear, and what else you've got in there :w00t:

That's the second or third R2 limits question we've had - I've now got that page on favourites, ready for the next one ;-).

I always find some of the limits...