Login or sign up Lost password?
Login or sign up
Original Example(s) at: table Primary Holder Table ( i int identity (1001,2) not null primary key, j int not null unique ) create table #Output Results Holder ( i int not null, j int not null) insert into Primary Holder Table (j) output inserted.i, inserted.j into #Output Results Holder select top 10 o.object_id from sys.objects as o order by o.object_id desc –You're running an UPDATE with a WHERE clause. Well, something has to "match" from the WHERE clause or anything to be updated.