I see, too. Or three. 😀

Thank you for the easy, back-to-basics question.

Revenant (7/13/2012)

---

SQLRNNR (7/13/2012)

---

mbova407 (7/13/2012)

---

Rich Weissler (7/13/2012)

---

So the correct answer is the Operating System limit.

Presumably, if I were to load SQL 2008 R2 Data Center Edition on Windows Server...

L' Eomot Inversé (7/15/2012)

---

Thanks to "El" Jerry, Jason, Lynn, Paul, Stefan, Gianluca, Bex, Grant, Brandie, Greg, Kiara, Revenant, Sean, Craig, Rodders, Dwain, Ray, Jeff, Jack, Wayne, Jan, and Gus ...

Thank you, Samith, for the back-to-basics question. To me, this is something that is learned and take for granted I will always remember it, so I had to re-read and...

Exploding Gremlins

"El" Jerry.

Thank you for the nice, easy, back-to-basics question.

"El" Jerry.

Thank you for the easy question, it also made me think and test about WHERE added to TRUNCATE in SS 2012, but after testing I wondered, would there be a...

Nice and easy back-to-basics question. Thank you, Sanjeewan.

"El" Jerry.

Nice question, thanks for the back to basics.

Happy weekend, everyone.

"El" Jerry.

I don't know what was the intention of this question, but it shouldn't have been included here. Having 2 possible answers where it should only have one is just pathetic.

"El"...

Congratulations, Gail.

"El" Jerry.

Thank you for the question.

I also agree that YYYYDDMM is rarely used anywhere, and I use YYYYMMDD as standard, as it is easier to interpret in any situation.

"El" Jerry.

Thank you, Wayne. Glad you liked it.

"El" Jerry.

Good question. Interesting that running the code one line at a time inserts one row and you get an error when executing COMMIT (No corresponding transaction exists). The error...