更新时间:2023-02-14 10:25:25
你是否传递了值通过页面...?
如果您通过页面传递值,请使用if检查条件。if (field1!= field2&& field1!= field3&& field1!= field4& & field2!= field3&& field2!= field4& ;& field3!= field4)
{
// insert query
}
我不确定这是你的期望,但根据我的理解,我给出了这个解决方案。
I want to Create a procedure for insert as in table have 7 weekdays such that suppose i have following fields mentioned below for the table as
Id employeename field1 field2 field3 field4
all fields are varchar data type
now condition should be that when i insert the record field1 value not equal to field2 so as for field1 not equal to field3 and field1 not equal to field4 and field2 not equal to field3 and field2 not equal to field4 and same for the field3 not equal to the field4
Are You Passed the values via Page...?
If you pass the values via page then check the condition using "if".if(field1!=field2 && field1!= field3 && field1 != field4 && field2 != field3 && field2 != field4 && field3!= field4) { // insert query }
i''m not sure this is your expecting but as per my understanding i given this solution .