在SQL Server2005里怎么把函数绑定到一个字段上!

-- 声明函数goCREATE FUNCTION GetPriceListStatus()returns intasbegin declare @ReturnV int declare @Sum bigint select @Sum = sum(pirce) from YourTable if @Sum >= 2000 and @Sum <40000 set @ReturnV = 1 else if @Sum >= 40000 and @Sum <10000 set @ReturnV = 2 else if @Sum >= 10000 and @Sum <150000 -- 150000可根据需要自行修改 set @ReturnV = 5 -- else if 省略 else set @ReturnV = 0 return @ReturnV endgoupdate YourTable2 set 字段= GetPriceListStatus() 收起