David Svedarsky
asked on
SQL Server query to change column value from 0 to 1
Software: SQL Server 2005
I am looking for a query to change a specific column value from 0 to 1.
Example:
I have a table column that is always numbered 0, 1, 2, 3, etc. I want to change it so it numbers 1, 2, 3, 4 etc
Thanks!
I am looking for a query to change a specific column value from 0 to 1.
Example:
I have a table column that is always numbered 0, 1, 2, 3, etc. I want to change it so it numbers 1, 2, 3, 4 etc
Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
ASKER
I have existing table entries with the value of 1 which I don't want the value changed.