|
Comments:
|
|
good video, I had forgetten about the on the fly function
|
|
|
Nice way to do it, at least it's less code than the one that I do:
SELECT ROW_NUMBER() OVER(ORDER BY TestID) AS MyID, * INTO NewTable2 FROM NewTable1
|
|
|
Did not know this trick. Thank you!
|
|
|
I love learning little tricks like this !!
|
|
|
yup
|
|
|
technique that's really handy!
|
|
|
Good tip!
|
|
|
Very usefull. Windowed functions like ROW_NUMBER() are not applicabale when need to keep the input sequence.
|
|
|
Rated as excellent.
I often have to use identities on the fly so it's a great tip to know.
|
|
|
interesting andy
|
|
|
It would be very helpful if the sample statement (showing the syntax to use) were available at the conclusion of the video as text that could be copied to the clipboard for use elsewhere. That would be for this and all other videos that include SQL examples.
Harvey
|
|
|
very cool...we have a need for this going on right now so this may be used in some refactoring work we're planning.
|
|
|
Was useful..
|
|
|
I would have like some more explaination about it. For instance, is it a good idea to use this technique or just create an identity column in a new table and copy stuff in it.
But really a good video. It helps you learn and ponder.
|