Stored Procedures [dbo].[JMO_SWB_Del]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@k_swb_namechar(65)65
@k_swb_resnchar(17)17
Permissions
TypeActionOwning Principal
GrantExecuteuniadmin
GrantExecuteemadmin
GrantExecutejmoadmin
SQL Script
/****** Object:  Stored Procedure dbo.JMO_SWB_Del    Script Date: 12/1/2005 11:49:34 PM ******/


CREATE proc JMO_SWB_Del (
   @k_swb_name      char(65),
   @k_swb_resn      char(17)
)
as
begin
   Delete From jmo_swb
   Where
       swb_name         = @k_swb_name      and
       swb_resn         = @k_swb_resn

end
GO
GRANT EXECUTE ON  [dbo].[JMO_SWB_Del] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_SWB_Del] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_SWB_Del] TO [uniadmin]
GO
Uses