Home Forums SQL Server 7,2000 T-SQL Update Top 1 RE: Update Top 1
Kenneth Wilhelmsson
SSC-Dedicated
Points: 30043
More actions
January 4, 2005 at 2:20 am
#535725
You are aware that by updating 'House' to 'Home' you are in fact also changing the Primary Key for that record? Have you carefully analyzed what the consequences of such an update would be for the integrity of your data?
/Kenneth