|
--select * from uv_wage_ext_charge
/* alter procedure usp_wage_ext_charge @wage_ym varchar(6),@emp_sn smallint = null
as
if @emp_sn is null
select * from uv_wage_ext_charge where wage_ym=@wage_ym
else
select * from uv_wage_ext_charge where wage_ym=@wage_ym and @emp_sn = @emp_sn
*/
exec usp_wage_ext_charge @wage_ym='200211',@emp_sn=294
---------------------------------------------------------------------------
結果如下:
200211 65 1 產量1.2分 18993.00 227.9160 NULL
200211 65 17 漏針難補 100.00 200.0000 NULL
200211 65 19 疏忽10元 2.00 20.0000 NULL
200211 65 24 計生証 1.00 5.0000 NULL
200211 294 6 爛針5米 9.30 18.6000 NULL
-------------------------------------
|
|