SQL中的if...else如何嵌套

tonyze 2009-02-16 04:20:08

我跟踪了一下，生成如下代码（有错误）

if((select count(*) from eap_history)=10)

update eap_history set Name='收款单',url='ARAP/ReceiveVoucherEdit.aspx?SourceType=FromMenu',code='ARAP01',recordtime='2009-02-16 15:58:04' where recordtime =(select min(recordtime) from eap_history)

else

if(exists(select * from eap_history where UserID ='8bbccdc8-b137-4a33-b253-7929b4473157' and code ='ARAP01'))
update eap_history set Name='收款单',url='ARAP/ReceiveVoucherEdit.aspx?SourceType=FromMenu',code='ARAP01',recordtime='2009-02-16 15:58:04' where userid='8bbccdc8-b137-4a33-b253-7929b4473157' and code ='ARAP01'

else

insert into eap_history values( 'a5a297b3-095f-4011-b210-c3d3af11b535', '收款单','ARAP/ReceiveVoucherEdit.aspx?SourceType=FromMenu','ARAP01','8bbccdc8-b137-4a33-b253-7929b4473157','2009-02-16 15:58:04')
end

...全文

4587 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

小坏 2010-09-11

打赏
举报

学习了

wjcper2008 2009-08-06

打赏
举报

aaaa

weijianliang 2009-08-02

打赏
举报

学习. 谢谢.

QQ306832666 2009-02-16

打赏
举报

顶楼上

xray2005 2009-02-16

打赏
举报



if((select count(*) from eap_history)=10) 

  begin

    update eap_history set Name='收款单',url='ARAP/ReceiveVoucherEdit.aspx?SourceType=FromMenu',code='ARAP01',recordtime='2009-02-16 15:58:04' where recordtime =(select min(recordtime) from eap_history) 

  end

else 

  begin

    if(exists(select * from eap_history where UserID ='8bbccdc8-b137-4a33-b253-7929b4473157' and code ='ARAP01')) 

       begin  

         update eap_history set Name='收款单',url='ARAP/ReceiveVoucherEdit.aspx?SourceType=FromMenu',code='ARAP01',recordtime='2009-02-16 15:58:04' where userid='8bbccdc8-b137-4a33-b253-7929b4473157' and code ='ARAP01' 

       end

    else 

       begin

          insert into eap_history values( 'a5a297b3-095f-4011-b210-c3d3af11b535', '收款单','ARAP/ReceiveVoucherEdit.aspx?SourceType=FromMenu','ARAP01','8bbccdc8-b137-4a33-b253-7929b4473157','2009-02-16 15:58:04') 

       end 

  end

stone_1207 2009-02-16

打赏
举报

基本上结构都一样，只是sql中{}用Begin和end代替

我姓区不姓区 2009-02-16

打赏
举报

加上begin和end，就相当于c#中的{和}

the_pain 2009-02-16

打赏
举报

sql中的if else

如果说条件下面只有一行的话就不用加begin end,不加的话则只执行if或else下的第一个SQL

若有多行的话
if
begin
.....
....
end
else
begin
...
..
...
end

真相重于对错 2009-02-16

打赏
举报

IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') < $15
BEGIN
PRINT 'The following titles are excellent mod_cook books:'
PRINT ' '
SELECT SUBSTRING(title, 1, 35) AS Title
FROM titles
WHERE type = 'mod_cook'
END
ELSE
PRINT 'Average title price is more than $15.'