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)
) AS
SET NOCOUNT ON
BEGIN
UPDATE dbo.t_duibiao_data
SET rs_bs_duibiao = @rsBsDuibiao,
rs_man_duibiao = @rsManDuibiao,
pingan_bs_duibiao = @pinganBsDuibiao,
pingan_man_duibiao = @pinganManDuibiao
WHERE id = @id

SELECT * FROM dbo.t_duibiao_data
WHERE id = @id

END;

ALTER PROC [dbo].[import_edit_nmg_duibiao_data] 
(
@id INT
) AS
SET NOCOUNT ON
BEGIN
select 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 dtt
WHERE b.id = @id
AND b.branch_id = dv.dim_value_code
AND b.sales_channel_id = dc.sales_channel_id
AND b.plat_id = dp.plat_id
AND b.date_type_id = dtt.date_type_id
END;