sql存储过程例子

/*说明：编辑更新一条记录*/ALTER PROC [dbo].[import_update_nmg_duibiao_data] (@id INT ,@rsBsDuibiao DECIMAL(12,2),@rsManDuibiao DECIMAL(12,2),@pinganBsDuibiao DECIMAL(12,2),@pinganManDuibiao DECIMAL(12,2)) ASSET NOCOUNT ONBEGINUPDATE dbo.t_duibiao_dataSET rs_bs_duibiao = @rsBsDuibiao,rs_man_duibiao = @rsManDuibiao,pingan_bs_duibiao = @pinganBsDuibiao,pingan_man_duibiao = @pinganManDuibiaoWHERE id = @idSELECT * FROM dbo.t_duibiao_dataWHERE id = @idEND;

ALTER PROC [dbo].[import_edit_nmg_duibiao_data] (@id INT) ASSET NOCOUNT ONBEGINselect b.id,b.date_id,dv.dim_value_name,dc.sales_channel_name,dp.plat_name,dtt.date_type_name,b.rs_bs_duibiao,b.rs_man_duibiao,b.pingan_bs_duibiao,b.pingan_man_duibiao from t_duibiao_data b,dim_value dv,dim_channel dc,dim_plat dp,dim_time_type dttWHERE b.id = @idAND b.branch_id = dv.dim_value_codeAND b.sales_channel_id = dc.sales_channel_idAND b.plat_id = dp.plat_idAND b.date_type_id = dtt.date_type_idEND;