步骤1：（执行下面脚本）
if exists(select name from sysobjects where name = 'F_UpdateGuestPrice' and type = 'FN')
drop function F_UpdateGuestPrice
GO

Create function F_UpdateGuestPrice(@FShopIDList varchar(8000))
returns varchar(8000)
as
begin
declare @Result varchar(8000)
if @FShopIDList = ''
set @Result = ''
else
begin
declare @I int, @J int
set @Result = ''
set @FShopIDList = @FShopIDList + ','
SET @I = 1
SET @J = CharIndex(',',@FShopIDList,1)
WHILE @J > 0
BEGIN
set @Result = @Result + ',0'
SET @I = @J + 1
SET @J = CharIndex(',',@FShopIDList,@I)
END
if @Result <> ''
set @Result = substring(@Result,2,len(@Result))
end
return @Result
end
GO

步骤2：（执行下面脚本）
UPDATE POS_FoodDef SET FoodDownGuestPriceList = dbo.F_UpdateGuestPrice(FoodDownShopList)
where FShopID=1000