Update Column using Loop in SQL Server

Question

Hi I have a Table that have a Primary Key [UserId] now I have just added another Column called [ReferenceNumber]. And ReferenceNumber required to update values copied from UserId in reverse. For Example: if userId =12 then ReferenceNumber would be updated by 21.

I have to loop through end of the table and update ReferenceNumber column.

 FOR LOOP TO --- From First Row to End 
     Update dbo.UserTable SET [ReferenceNumber ]=
          (SELECT REVERSE([UserId]) FROM dbo.UserTable) 
 END

Please Advice

Gordon Linoff · Accepted Answer · 2016-06-09 10:53:18Z

1

Does this do what you want?

update dbo.UserTable
    set ReferenceNumber = reverse(UserId);

There is no need for an explicit "loop". The update matches all matching rows in the table.

answered Jun 9, 2016 at 10:53

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update Column using Loop in SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related