set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[STPEditListStock] @GoodSyscode int, @Title nvarchar(1000)='', @FstUnit nvarchar(1000)='', @SecUnit nvarchar(1000)='', @OrderPoint real, @SalePrice1 money, @SalePrice2 money, @SalePrice3 money, @SalePrice4 money, @SalePrice5 money, @VisitorPer float, @Comment nvarchar(1000)='', @DiscontPer float, @UserPrice money, @weight real, @Term nvarchar(1000), @Typeid int, @GroupId1 int, @groupId2 int AS if @GoodSyscode<0 return 1 UPDATE StockTbl SET Title = @Title, FstUnit = @FstUnit, SecUnit = @SecUnit, OrderPoint = @OrderPoint, SalePrice1 = @SalePrice1, SalePrice2 = @SalePrice2, SalePrice3 = @SalePrice3, SalePrice4 = @SalePrice4, SalePrice5 = @SalePrice5, VisitorPer = @VisitorPer, Term = @Term, Comment = @Comment, DiscontPer = @DiscontPer, UserPrice = @UserPrice, Weight = @weight, GroupID1 = @GroupID1, GroupID2 = @groupid2, Type = @typeid WHERE (GoodSyscode = @GoodSyscode)