How to update my identity column Id ? I get the Msg 8102, Level 16, State 1, Line 1 Cannot update identity column 'Id'.
when i try to update id
update [WarehouseReports].[Reports]
set Id=Id+1
where Id=20
Asked
Active
Viewed 7,142 times
4
user2171512
- 511
- 1
- 8
- 24
-
Why would you want to do this? – Stefan Steinegger Jun 30 '15 at 08:32
-
1Can you try this: http://stackoverflow.com/q/3947453/2451726 – Arulkumar Jun 30 '15 at 08:42