且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

sql存储过程查询

更新时间: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 .