BDG Scenario 1

fm_admin_update_item.sql

If Exists (Select * From sysobjects Where name = N'fm_admin_update_item' And user_name(uid) = N'dbo')
    Drop Procedure dbo.fm_admin_update_item
Go

create procedure fm_admin_update_item (
   @itemNo integer,
   @barcode varchar(16),
   @bibNo integer,
   @location varchar(64),
   @source varchar(64),
   @price money,
   @notes varchar(255),
   @staff_only tinyint,
   @item_status varchar(7)
) as
   set nocount on

   if @itemNo > 0
      update item set barcode=@barcode, bib#=@bibNo, location=@location, source=@source,
             price=@price, notes=@notes, staff_only=@staff_only, item_status=@item_status
             where item#=@itemNo
   else
   begin
      insert into item(barcode, bib#, location, source, price, notes, staff_only, item_status)
             values(@barcode, @bibNo, @location, @source, @price, @notes, @staff_only, @item_status)
      select @itemNo = @@IDENTITY
   end

   return @itemNo


Go