Dave62 (2/13/2013)

---

By the way I also appreciate your extensive knowledge and contributions here. I find some of your posts educational, some entertaining, and some are both.

Enjoy!

john.arnott (2/13/2013)

---

[quote]I know I'm late to this party, but have to ask. What 4th statement? I see a Create Table, a Select Into and then a Select. Was the original code edited between publication and today?

Hugo Kornelis (2/11/2013)

---

I'm surprised you didn't know this. Integer is actually the official name; int is an accepted abbreviation.
*cough* I have to retract the above. That's what I always thought, but when I went out to find a Books Online reference, I was surprised to see only "int" there. "Integer" is not even mentioned.

EDIT: Found the source of my confusion. The ANSI documents describing the SQL standard define both INT and INTEGER, and describe INT as "equivalent to INTEGER". I've always interpreted that as "INTEGER" being the official form and "INT" being an accepted alternative.

crazy_s245 21087 (2/19/2013)

---

This code works in SQL 2005 and returns the inserted row, only there was error "Column, parameter, or variable #4: Cannot find data type Date". Same code didn't work in SQL 2012.

Can any one please explain why this code worked in SQL 2005?