Stored Procedures [dbo].[JMO_MWC_Ins]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@mwc_cluschar(21)21
@mwc_namechar(17)17
@mwc_brtint4
@mwc_brvsmallint2
@mwc_descvarchar(255)255
Permissions
TypeActionOwning Principal
GrantExecuteuniadmin
GrantExecuteemadmin
GrantExecutejmoadmin
SQL Script
/****** Object:  Stored Procedure dbo.JMO_MWC_Ins    Script Date: 12/1/2005 11:49:22 PM ******/


CREATE proc JMO_MWC_Ins (
   @mwc_clus         char(21),
   @mwc_name         char(17),
   @mwc_brt          int,
   @mwc_brv          smallint,
   @mwc_desc         varchar(255)
)
as
begin
   Insert into jmo_mwc (
      mwc_clus,
      mwc_name,
      mwc_brt,
      mwc_brv,
      mwc_desc
)
   Values (
      @mwc_clus,
      @mwc_name,
      @mwc_brt,
      @mwc_brv,
      @mwc_desc
)
end
GO
GRANT EXECUTE ON  [dbo].[JMO_MWC_Ins] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_MWC_Ins] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_MWC_Ins] TO [uniadmin]
GO
Uses