|
Comments
|
|
Perfect.
|
|
|
Straight to the point, with a good example I love it.
|
|
|
Did not know you could do that. Wish there was a way in MS Access to do the same thing.
|
|
|
concise no distractions
|
|
|
Very useful information. Thank you very much.
|
|
|
Pretty basic stuff, but well done nonetheless. I was hoping for code that would find the gap in the sequence and use that 'missing' value for the ID as the next record was inserted. ;-p
|
|
|
I did not know that ... Intersting
|
|
|
This vedio is indeed usefull. Can you come up with more vedios on ow to create Expressions in SSIS packages.
More realistic examples on building expressions.
|
|
|
This vedio is indeed usefull. Can you come up with more vedios on ow to create Expressions in SSIS packages.
More realistic examples on building expressions.
|
|
|
This is something that everyone needs. Great Video.
|
|
|
To use this to back fill key values then one could simply create a SQL block that started by turning on and ending by turning off the identity feature. This was a very useful topic.
|
|
|
i've been in that situation before..
|
|
|
For Chris: Find a gap in identity column. Please see this link http://msdn.microsoft.com/en-us/library/aa933196%28SQL.80%29.aspx, You can make this code in the form of function or stored procedure. I've tried it, very simple.
|
|
|
another great share
|
|
|
Great, thanks! Another thing I learned that wasn't explicitly in the video is that, when IDENTITY_INSERT is set to ON, you can add several rows with the same key value (not what we want usually). So, another reason to be sure to turn it OFF after replacing the deleted row.
|
|
|
Very helpful. Thanks.
|
|
|
Very good tip - thanks.
|
|
|
Video muito bom, excelente explicação sobre operação com campos identity.
|
|
|
Useful trick.
|
|
|
Awesome example, Is there any way to copy paste your code and try it ourselves to practice.
|