Hello, I'm looking for an equivalent of the Oracle RowNum function in SQL
Server, or some other method of solving this problem.
In the DDL below I'm inserting three values - Rod, Jane and Freddy with a
type of Rainbow. I want to re-insert them again with a type of Entertainers
but I want them to have unique identity keys.
I'd rather not drop the table and recreate it with an identity field as I've
got 10 million rows to do and it will take all day. The design is just
fictitious but it's an example of the kind of ...