It seems that you are well famaliar in SQL, so can you tell is it always needed to have a primary key, in table and is it needed to have a identity primary key?

what happens if i have no primary key or have a primary key but a non-identity one?

your code will not work.

Still i appreciate your hard work