To add incremental numbers into a column (not an auto increment column) is easy with a stored procedure but we can use a simple update also. done.
Archive for the 'mssql' Category
20 Mar 2020
update semi-incremental column
15:16 |
mssql |
972 views
26 Dec 2019
mssql – custom start value for identity column
20:55 |
mssql |
890 views
You can give an initial value for the identity column when you are creating the new table. If you want an identity column which one is starts from zero If the table already created you can override the identity column startValue with the following command: where the tableName is the target table name startValue is […]
You can give an initial value for the identity column when you are creating the new table. If you want an identity column which one is starts from zero If the table already created you can override the identity column startValue with the following command: where the tableName is the target table name startValue is […]
23 Nov 2014
missing tempdb.dbo.ASPStateTempApplications table
13:23 |
mssql |
1181 views
Goal: to solve the missing tempdb.dbo.ASPStateTempApplications table problem Just recreate this temp object with the following code snippet:
Goal: to solve the missing tempdb.dbo.ASPStateTempApplications table problem Just recreate this temp object with the following code snippet: