Update query using select statement of updating table

Question

In Mssql i want to update a column col1 in table named Table1 using select query which returns col1 from Table1 and add 1 to it. So i used the following code

update Table1 set col1=(select col1 from Table1) + 1;

But when i used it says you cannot target same table.Is there any ways to work out this function. Please help to find it out.

Thanks in advsnce

echo_Me · Accepted Answer · 2013-03-12 09:17:56Z

2

you can do it like that

     update Table1 set col1= col1 + 1;

answered Mar 12, 2013 at 9:17

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

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

Collectives™ on Stack Overflow

Update query using select statement of updating table

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