So, if you had a table created with:
CREATE TABLE ROB/IDTEST
(MYIDCOL INT NOT NULL AS IDENTITY
SomeChar char (25),
PRIMARY KEY (MYIDCOL))
and you inserted a few rows into it and now have
And you run this:
delete from rob/idtest where somechar='b'
you want to know if you can run this:
with t1 as (
select rank() over(order by myidcol ASC) as newid,
order by myidcol ASC)
set myidcol=(select newid
No. but there may be some alteration of that possible.