Tag Archives: SQL

Incrementing ID on a SQL row that you cannot use the Identity property with.

This is most common when the identity is not the primary key, and is tracked independently for each Foreign Key Ref. Example: Field Type OrderID Uniqueidentifier FK to the the order table. LineNumber Int The column that we need each … Continue reading

Posted in Brian's Code Extreme, SQL, T-SQL | Tagged , , | Leave a comment