Stored Procedures [dbo].[JMO_MWC_Selp]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@k_mwc_cluschar(21)21
@k_mwc_namechar(17)17
Permissions
TypeActionOwning Principal
GrantExecuteemadmin
GrantExecuteemuser
GrantExecutejmoadmin
GrantExecutejmouser
GrantExecuteuniadmin
GrantExecuteuniuser
SQL Script
/****** Object:  Stored Procedure dbo.JMO_MWC_Selp    Script Date: 12/1/2005 11:49:22 PM ******/


CREATE proc JMO_MWC_Selp (
   @k_mwc_clus      char(21),
   @k_mwc_name      char(17)
)
as
begin
   Select
      mwc_clus,
      mwc_name,
      mwc_brt,
      mwc_brv,
      mwc_desc
   From jmo_mwc
   Where
       mwc_clus         >= @k_mwc_clus      and
       mwc_name         >= @k_mwc_name
   Order by
       mwc_clus,
       mwc_name
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_MWC_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_MWC_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_MWC_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_MWC_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_MWC_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_MWC_Selp] TO [uniuser]
GO
Uses