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

CREATE proc JMO_HSTU_Ins (
   @hst_scdn         char(65),
   @hst_name         char(65),
   @hst_jno          char(5)   
)

as
begin
   Insert into jmo_hstu (
      hst_scdn,
      hst_name,
      hst_jno      
)
   Values (
      @hst_scdn,
      @hst_name,
      @hst_jno      
)
end
GO
GRANT EXECUTE ON  [dbo].[JMO_HSTU_Ins] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_HSTU_Ins] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_HSTU_Ins] TO [uniadmin]
GO
Uses