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


CREATE proc JMO_TRG_Del (
   @k_trg_trev      char(8),
   @k_trg_trid      char(64)
)
as
begin
   Delete From jmo_trg
   Where
       trg_trev         = @k_trg_trev      and
       trg_trid         = @k_trg_trid

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