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






CREATE proc JMO_JBR_DelT (
   @k_jbr_scdn      char(65),
   @k_jbr_name      char(65),
   @k_jbr_jno       char(5)
   
)
as
begin
   Delete From jmo_jbr
   Where
       jbr_name         = @k_jbr_name      and
       jbr_jno          = @k_jbr_jno       and
       jbr_scdn         = @k_jbr_scdn

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