Hi DB Guys,
I am inserting a bulk data into table which had a primary key as Char + Identity Column
So in SP i wrote a script like getting max of Identity and adding Char value and then i am inserting in to DB.
But the problem it's a live project traffic is more
so my script is not working in Prod
It's throwing error Primary key violation.
I hope you guys understand my issue and u guys already faced this issue.
So please provide some solution for this.