Skip to content
Advertisement

Already inserted data replace into another UserId

In my Business unit table FK is the UserId

ex: UserId =001, BusinessUnit = Bangalore

ex: UserId =001, BusinessUnit = Hyd ….

Now, I need UserId = 002 is different I want to create same data into 002

The INSERT statement conflicted with the FOREIGN KEY constraint “FK_UserAccess_UserDetails”.

The conflict occurred in database “DataBase Name”, table “dbo.UserDetails”, column ‘UserId’.

Advertisement

Answer

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement