一条删除语句,报错。delete from users where UserAccount='tjguest' ,这一条SQL语句执行时报错,错误信息如下:消息 547,级别 16,状态 0,第 1 行
The DELETE statement conflicted with the REFERENCE constraint "FK_USERPOPE_REFERENCE_CUSERS". The conflict occurred in database "newcems", table "dbo.UserPopedom", column 'UserNo'.
The statement has been terminated.问题:怎么回事??? 怎样才能将该记录删除???
The DELETE statement conflicted with the REFERENCE constraint "FK_USERPOPE_REFERENCE_CUSERS". The conflict occurred in database "newcems", table "dbo.UserPopedom", column 'UserNo'.
The statement has been terminated.问题:怎么回事??? 怎样才能将该记录删除???
是的话先把对应的外间的这个UserAccount='tjguest'的数据删除在回来删除逐渐所在的表的数据