Click here to Skip to main content
15,068,645 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
can i use same column of same table for set and where clauses in update command.
Posted

1 solution

Yes you can.
Update table set myCol=value1 where myCol=value2
   
Comments
RaviRanjanKr 23-Jul-11 7:09am
   
you beat me. I was going to write same answer.
whatever, My 5+
Abhinav S 23-Jul-11 7:13am
   
:) Thanks for the 5 Ravi.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900