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

CREATE proc JMO_HSTU_Self (
   @k_hst_scdn      char(65),
   @k_hst_name      char(65),
   @k_hst_jno       char(5)
)
as
begin
   Select
      hst_scdn,
      hst_name,
      hst_jno      
   From jmo_hstu
   Where
       hst_scdn         = @k_hst_scdn      and
       hst_name         = @k_hst_name      and
       hst_jno          = @k_hst_jno       
   Order by
       hst_scdn,
       hst_name,
       hst_jno
end
GO
GRANT EXECUTE ON  [dbo].[JMO_HSTU_Self] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_HSTU_Self] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_HSTU_Self] TO [uniadmin]
GO
Uses