I have a table in SQL Server I want my registerNumber to be of type batch+branch+id eg a row in student id:1, batch:17, branch:BIT then the registerNumber should be 17BIT1 I tried to do this by using a default value in create table but it does not allow me to reference the columns of the same table edit thank you
Tag: surrogate-key
Using Surrogate Keys in Data Warehouse Pros and Cons
A surrogate key is a mechanism that exists in our books for years and I hate for bringing into discussion again. Everyone is talking about the benefits of using a surrogate key instead of a business key. Even Microsoft Analysis Services Tabular and Microsoft PowerBI Tabular Models are working with the surrogate key. Both platforms mentioned give you the ability