how to increment integer Columns value by 1 in SQL

by

To add one to every value in the table…

UPDATE myTable
SET ID = ID + 1

To create a new value, one more then the previous highest (usually), use a column with IDENTITY

More Related Contents:

  1. How can I do an UPDATE statement with JOIN in SQL Server?
  2. SQL update query using joins
  3. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  4. The multi-part identifier could not be bound
  5. updating table rows in postgres using subquery
  6. Fastest way to update 120 Million records
  7. Can a Check constraint relate to another table?
  8. Is it possible to select sql server data using column ordinal position
  9. how can I Update top 100 records in sql server
  10. How to find current transaction level?
  11. How to insert multiple records and get the identity value?
  12. How can a LEFT OUTER JOIN return more records than exist in the left table?
  13. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  14. Dynamic SQL to generate column names?
  15. Extracting hours from a DateTime (SQL Server 2005)
  16. Column name or number of supplied values does not match table definition
  17. How to split string using delimiter char using T-SQL?
  18. SQL Server PIVOT perhaps?
  19. How to find consecutive rows based on the value of a column?
  20. Custom aggregate function (concat) in SQL Server
  21. Bulk/batch update/upsert in PostgreSQL
  22. How to escape square brackets inside square brackets for field name
  23. Functions with variable number of input parameters
  24. Average of multiple columns
  25. What is the internal representation of datetime in sql server?
  26. How to change column order in a table using sql query in sql server 2005?
  27. Why do SQL Server Scalar-valued functions get slower?
  28. SQL query for parent-child chain
  29. Querying Active Directory from SQL Server 2005
  30. Update a table with data from another table

Leave a Comment