Modify SQL

[uglyFairy]

declare @condition1 varchar(20)
declare @condition11 varchar(20)
declare @condition12 varchar(20)

declare @condition2 varchar(20)
declare @condition21 varchar(20)
declare @condition22 varchar(20)

set @condition1 = '1'
set @condition11 = '1'
set @condition12 = '2'

set @condition2 = '2'
set @condition21 = '1'
set @condition22 = '2'

select * from UMA0BA where
case @condition1 when '1' then Hojokbncd = '0'
case @condition11 when '1' then 'and Genskbn = '0' and Kmkcd = '1''
case @condition12 when '2' then 'and Genskbn = '1' and Kmkcd = '2'' end

case @condition2 when '2' then Hojokbncd = '1'
case @condition21 when '1' then 'and Genskbn = '0' and Kmkcd = '1''
case @condition22 when '2' then 'and Genskbn = '1' and Kmkcd = '2'' end

[子陌红尘]

U想干什么？

[子陌红尘]

Oracle 9i以后版本才支持case ... when ... 语句，而且，似乎也不是这么用的...

[CodeMagic]

select * from UMA0BA where Hojokbncd =&1 and Genskbn =&2 and Kmkcd =&3

[baojianjun]

恩？SQL SERVER的東西

[baojianjun]

哈哈，是要翻譯呀

[liuwang2000]

UP

[progrose]

SQL SERVER的东西搞这来了。

[uglyFairy]

是在Oracle 9i中实现.