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


CREATE proc JMO_NOD_Upd (
   @nod_name         char(65),
   @nod_ckpt         char(16),
   @nod_boot         char(16),
   @k_nod_name       char(65)
)
as
begin
   Update jmo_nod
   Set
      nod_name         = @nod_name,
      nod_ckpt         = @nod_ckpt,
      nod_boot         = @nod_boot
   From  jmo_nod WITH (index=1)
   Where
      nod_name         = @k_nod_name
end
GO
GRANT EXECUTE ON  [dbo].[JMO_NOD_Upd] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_NOD_Upd] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_NOD_Upd] TO [uniadmin]
GO
Uses