CASE 语法在存贮过程中怎用?
CASE 语法在存贮过程中怎用?

CREATE PROCEDURE qd_proaddcl
@cltable1 char(10)
as
case cltable1= 'yl11 '
insert into yl11 (pzhm,rq,sl) values (...)
case cltable1= 'yl12 '
insert into yl12(pzhm,rq,sl) values (...)

[解决办法]
改用IF吧


CREATE PROCEDURE qd_proaddcl
@cltable1 char(10)
as
If cltable1= 'yl11 '
insert into yl11 (pzhm,rq,sl) values (...)
Else If cltable1= 'yl12 '
insert into yl12(pzhm,rq,sl) values (...)