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 (...)