Stored Procedures [dbo].[JMO_SWB_Ins]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@swb_namechar(65)65
@swb_resnchar(17)17
@swb_srtint4
@swb_srvsmallint2
@swb_flagbinary(1)1
@swb_descvarchar(255)255
Permissions
TypeActionOwning Principal
GrantExecuteemadmin
GrantExecutejmoadmin
GrantExecuteuniadmin
SQL Script
/****** Object:  Stored Procedure dbo.JMO_SWB_Ins    Script Date: 12/1/2005 11:49:34 PM ******/


CREATE proc JMO_SWB_Ins (
   @swb_name         char(65),
   @swb_resn         char(17),
   @swb_srt          int,
   @swb_srv          smallint,
   @swb_flag         binary(1),
   @swb_desc         varchar(255)
)
as
begin
   Insert into jmo_swb (
      swb_name,
      swb_resn,
      swb_srt,
      swb_srv,
      swb_flag,
      swb_desc
)
   Values (
      @swb_name,
      @swb_resn,
      @swb_srt,
      @swb_srv,
      @swb_flag,
      @swb_desc
)
end
GO
GRANT EXECUTE ON  [dbo].[JMO_SWB_Ins] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_SWB_Ins] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_SWB_Ins] TO [uniadmin]
GO
Uses