vahid_erad
دوشنبه 07 تیر 1389, 22:48 عصر
سلام
من هنگام select كردن بانك به ارور زير بر ميخورم.
Failed to enable constraints.One or more rows contain values violatin non-null,unique,or foreign-key constraints.
دستور select هم بصورت زير است.
SELECT [Khedmat].[ID],[ND],[SN],[PC],[NE],[PN],[SP],[MG],[MR],[MP],[MS],[MI]
FROM [Noskhe] inner join [Khedmat]
on [Noskhe].[NUM]=[Khedmat].[NUM]
where (Nos=@nos1 or Nos=@nos2) AND (SG = @SG) AND (ND between @start AND @end)
order by [MG],[ND]
ID كليد براي Khedmat
Num كليد براي Noskhe
مشكلش چيه؟؟
من هنگام select كردن بانك به ارور زير بر ميخورم.
Failed to enable constraints.One or more rows contain values violatin non-null,unique,or foreign-key constraints.
دستور select هم بصورت زير است.
SELECT [Khedmat].[ID],[ND],[SN],[PC],[NE],[PN],[SP],[MG],[MR],[MP],[MS],[MI]
FROM [Noskhe] inner join [Khedmat]
on [Noskhe].[NUM]=[Khedmat].[NUM]
where (Nos=@nos1 or Nos=@nos2) AND (SG = @SG) AND (ND between @start AND @end)
order by [MG],[ND]
ID كليد براي Khedmat
Num كليد براي Noskhe
مشكلش چيه؟؟