Stored Procedures [dbo].[JMO_JWB_Ins]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@jwb_scdnchar(65)65
@jwb_namechar(65)65
@jwb_jnochar(5)5
@jwb_resnchar(17)17
@jwb_srtint4
@jwb_srvsmallint2
@jwb_flagbinary(1)1
@jwb_descvarchar(255)255
Permissions
TypeActionOwning Principal
GrantExecuteemadmin
GrantExecutejmoadmin
GrantExecuteuniadmin
SQL Script
/****** Object:  Stored Procedure dbo.JMO_JWB_Ins    Script Date: 12/1/2005 11:49:21 PM ******/


CREATE proc JMO_JWB_Ins (
   @jwb_scdn         char(65),
   @jwb_name         char(65),
   @jwb_jno          char(5),
   @jwb_resn         char(17),
   @jwb_srt          int,
   @jwb_srv          smallint,
   @jwb_flag         binary(1),
   @jwb_desc         varchar(255)
)
as
begin
   Insert into jmo_jwb (
      jwb_scdn,
      jwb_name,
      jwb_jno,
      jwb_resn,
      jwb_srt,
      jwb_srv,
      jwb_flag,
      jwb_desc
)
   Values (
      @jwb_scdn,
      @jwb_name,
      @jwb_jno,
      @jwb_resn,
      @jwb_srt,
      @jwb_srv,
      @jwb_flag,
      @jwb_desc
)
end
GO
GRANT EXECUTE ON  [dbo].[JMO_JWB_Ins] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_JWB_Ins] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_JWB_Ins] TO [uniadmin]
GO
Uses