Hi i want to update a single column of data that is part of a PK is this possible to do, the only way i can see how to do it, it to remove the PK change the data and reset the PK, but i don't think this is the correct way of doing it.
You can update data that is part of a primary key. If the column is defined as an IDENTITY column, you will need to issue SET IDENTITY INSERT ON before your update, and SET IDENTITY INSERT OFF immediately afterwards.
Change PK data in row
Posted - 09/25/2007 : 07:45:21
