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


CREATE proc JMO_NOD_Selp (
   @k_nod_name      char(65)
)
as
begin
   Select
      nod_name,
      nod_ckpt,
      nod_boot
   From jmo_nod
   Where
       nod_name         >= @k_nod_name
   Order by
       nod_name
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_NOD_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_NOD_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_NOD_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_NOD_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_NOD_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_NOD_Selp] TO [uniuser]
GO
Uses