All online free dating chatting professionals 2015 - Sql updating primary key value


sql updating primary key value-74sql updating primary key value-4

Originally posted by rasmasyean How else are you going to change the keyed column without an UPDATE statement?

I would guess that you have to copy the row to a buffer, modify the buffered row, DELETE the row, then INSERT the buffered row back into the table. Brett and Tara are saying that it is considered bad practice to update/change a primary key.

I do not think that primary key data should ever be updated.

Tara Kizer Microsoft MVP for Windows Server System - SQL Server to my blog"Let's begin with the premise that everything you've done up until this point is wrong."Originally posted by X002548HOWEVERI don't consider it a good practice to do so, and prevent my developers for requiring CASCADING anything To me a key is a key If for some reason, the great state of NJ (Mob Central) what's to change it's name.that state ceased to exist, and there would be an end date of it's existance....would not want to associate our glorious past with what may happen with today's election Brett8-) Well you gotta update your profile so we know where you are from And you don't, the mob could be running your industries Also, here in NJ, it's not a choice of the best politian, it's the choice of the best crooked politician The bad ones get caught, then there's a big mess, then you gotta re-elect someone...you're not careful it could be a vicious cycle Brett8-)Originally posted by X002548HOWEVERI don't consider it a good practice to do so, and prevent my developers for requiring CASCADING anything To me a key is a key If for some reason, the great state of NJ (Mob Central) what's to change it's name.that state ceased to exist, and there would be an end date of it's existance....would not want to associate our glorious past with what may happen with today's election Brett8-)Originally posted by tkizer I completely agree with you, Brett.

Sales Person table because there is a logical relationship between sales orders and salespeople.