For auto incrementing the emp I'd value, the inserted value will automatically place after emp I'd 6, if we didn't mention the set identity insert on it will add at the end
It's a computed column...based on date of birth column so when you give date of birth value, age will be automatically calculated so no need to specify the age value
Super
Thanks
Very useful brother 👍🏻
Thanks
can you please share the EngineersDesk database for practice
Ok, will import the script and share
What is the purpose of using set identity_insert on
For auto incrementing the emp I'd value, the inserted value will automatically place after emp I'd 6, if we didn't mention the set identity insert on it will add at the end
Do we need to set IDENTITY_INSERT off again?
Not for this purpose, but it's always a good practice to use that
Why u deleted age sir
It's a computed column...based on date of birth column so when you give date of birth value, age will be automatically calculated so no need to specify the age value