/****** Object:  Stored Procedure dbo.JMO_SWB_Upd    Script Date: 12/1/2005 11:49:34 PM ******/


CREATE proc JMO_SWB_Upd (
   @swb_name         char(65),
   @swb_resn         char(17),
   @swb_srt          int,
   @swb_srv          smallint,
   @swb_flag         binary(1),
   @swb_desc         varchar(255),
   @k_swb_name       char(65),
   @k_swb_resn       char(17)
)
as
begin
   Update jmo_swb
   Set
      swb_name         = @swb_name,
      swb_resn         = @swb_resn,
      swb_srt          = @swb_srt,
      swb_srv          = @swb_srv,
      swb_flag         = @swb_flag,
      swb_desc         = @swb_desc
   From  jmo_swb WITH (index=1)
   Where
      swb_name         = @k_swb_name      and
      swb_resn         = @k_swb_resn
end
GO
GRANT EXECUTE ON  [dbo].[JMO_SWB_Upd] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_SWB_Upd] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_SWB_Upd] TO [uniadmin]
GO