Insert statement (please read again)

  • Thread starter Thread starter Seema
  • Start date Start date
S

Seema

have two tables. Roles and Users. In Roles I have three columns iID(PK),
Role(varchar), Description(varchar).

In User table I have columns ID(PK,FK), Username(varchar),
Password(varchar), Role(int).
First I fill data in Roles table then now I am trying to insert data in User
table it is giving me following error.

Msg 547, Level 16, State 0, Line 1
The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_User_Role". The conflict occurred in database "DataFeed", table
"dbo.Role", column 'Id'.
The statement has been terminated.
 
 have two tables. Roles and Users. In Roles I have three columns iID(PK),
Role(varchar), Description(varchar).

In User table I have columns ID(PK,FK), Username(varchar),
Password(varchar), Role(int).
First I fill data in Roles table then now I am trying to insert data in User
table it is giving me following error.

Msg 547, Level 16, State 0, Line 1
The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_User_Role". The conflict occurred in database "DataFeed", table
"dbo.Role", column 'Id'.
The statement has been terminated.
Click to expand...

Again, it seems you tried to insert a record in the User table with
Role which is not presented in the Roles table
 
Back
Top