Some Notes, Some Scripts

These are the noted taken for searching solutions and some scripts to identify the problem


Assume that all we know why we are using IDENTITY column in a table. It you are inserting any row and getting error: “Server: Msg 8101, Level 16, State 1, Line 2An explicit value for the identity column […]