Since I work in Orlando, I'll probably go.

Cool...

Jeff Moden (11/12/2010)

---

sqldba_icon (11/12/2010)

---

Just wanted to throw out a question to developers on what method do they use to loop around different objects.I typically use cursors, was wondering if...

Paul White NZ (11/14/2010)

---

Delete the row and then re-insert it with the correct identity value specified explicitly.

You will need SET IDENTITY_INSERT...

Paul White NZ (11/14/2010)

---

GSquared (11/11/2010)

---

And that's why there need to be two different versions of null. One for "we don't know" and another for "we don't care". (Okay,...

http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Dstripbooks&field-keywords=sql+server&x=11&y=25

Per MSDN:

KEY INDEX index_name

Is the name of the unique key index on table_name. The KEY INDEX must be a unique, single-key, non-nullable column. Select the smallest unique key index for...

Nope. Pretty sure there isn't. Kind of a cool feature.

Do post on an Oracle support site as well. You're much more likely to get good help on a site with more Oracle devs and DBAs than on this...

If you really do need to loop through a dataset, then a cursor is a perfectly valid way to do it. The problem with cursors isn't that, it's that...

Look over their articles/forums/whatever the have, and see if it makes sense to you. See if the environment is friendly for newbies or hostile/arrogant. Try a few out,...

GilaMonster (11/12/2010)

---

Hell no, then they'll be expecting...

That's pretty much the exact scenario dynamic SQL is meant to handle. You'll either want to build the query dynamically in the front end, or on the database server,...

I have to agree with David on this one. An identity column on that table doesn't make sense except as a lazy clustered index (and rental date-time would almost...

You can't update an identity row, and you shouldn't. Nor should you need to.

Are you trying to put row numbers on something? If so, either use the Row_Number()...