Archive for the 'mssql' Category


20 Mar 2020

update semi-incremental column

15:16 | mssql | 972 views

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.


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 […]


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:



#sidebar a { color:#fff; } #sidebar ul ul li { color: #DEF585; } #sidebar h2 { color: #fff; } #sidebar ul p, #sidebar ul select { color: #BEDDBE; } #backfly { background: url(images/golfBallWallPaper.jpg) left bottom fixed repeat-x #65a51d; }