Stored Procedures [dbo].[tng_add_manuf]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@idint4
@namevarchar(30)30
@vendor_namevarchar(10)10
@commentvarchar(80)80
Permissions
TypeActionOwning Principal
GrantExecuteuniadmin
GrantExecutewvadmin
SQL Script
/****** Object:  Stored Procedure dbo.tng_add_manuf    Script Date: 12/1/2005 11:49:41 PM ******/

CREATE procedure tng_add_manuf (@id int, @name varchar(30), @vendor_name varchar(10),
          @comment varchar(80)  )
    as  
insert into tng_vendor (vendor_id, name, vendor_name, comment )
             values (@id, @name, @vendor_name, @comment )
GO
GRANT EXECUTE ON  [dbo].[tng_add_manuf] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[tng_add_manuf] TO [wvadmin]
GO
Uses