如何使用if else条件编写过程 [英] how to write procedure using if else condition

问题描述

  SELECT  '   - 全部 - '  as  farmername  union  从中选择 farmername  k_Master_AddHatchingFarmer 其中​​ attrited = '  False'  order   by  farmername 
 
 选择 '   - 全部 - '  as  agentname  union   SELECT  agentname 来自 k_Master_AddHatchingAgent 其中​​ attrited = '  Fal se' 订单 按 agentname 
 
 选择 '   - 全部 - '  as  farmername  union  选择 farmername 来自 k_Master_Farmrecord 其中​​ attrited  in （ '  false'） order   by  farmername 

这三个条件，

如果农名是来自前端，那么执行1 st条件

否则如果agentname 2声明

else 3 rd statement





请帮帮我

解决方案

使用如下

  IF  farmername<> ' ' 
  BEGIN  
  SELECT  '   - 全部 - '  as  farmername  union  选择 farmername 来自 k_Master_AddHatchingFarmer 其中 attrited = '  False'  order   by  farmername 
 < span class =code-keyword> END  
  ELSE   IF  agentname< ;> ' ' 
  BEGIN  
 选择 '   - 全部 - '  as  agentname  union   SELECT  agentname 来自 k_Master_AddHatchingAgent 其中 attrited = '  False'  order   by  agentname 
 < span class =code-keyword> END  
  ELSE  
  BEGIN  
 选择 '   - 全部 -  - '  as  farmername  union  选择 farmername 来自 k_Master_Farmrecord 其中 attrited 中的code-keyword>（'  false'）订单 按 farmername 
  END  

谢谢，

-RG

 如果（条件）
 开始 
 statement1 
  end  
  else   if  （条件）
 开始 
 statement2 
  end  
  else  
  begin  
 statement3 
 端 

SELECT '--All--' as farmername union select farmername from k_Master_AddHatchingFarmer where attrited = 'False' order by farmername

select '--All--' as agentname union SELECT agentname from k_Master_AddHatchingAgent where attrited = 'False' order by agentname

select '--All--' as farmername union select  farmername from k_Master_Farmrecord where attrited in('false') order by farmername

These are three condition,
if farmername is from front end,then execute 1 st condition
else if agentname 2 statement
else 3 rd statement


please help me

解决方案

Use as below

IF farmername <> ''
BEGIN 
SELECT '--All--' as farmername union select farmername from k_Master_AddHatchingFarmer where attrited = 'False' order by farmername
END
ELSE IF agentname <> ''
BEGIN 
select '--All--' as agentname union SELECT agentname from k_Master_AddHatchingAgent where attrited = 'False' order by agentname
END
ELSE
BEGIN
select '--All--' as farmername union select  farmername from k_Master_Farmrecord where attrited in('false') order by farmername
END

Thanks,
-RG

if (condition)
begin
statement1
end
else if(condition)
begin
statement2
end
else 
begin
statement3
end

这篇关于如何使用if else条件编写过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！