不知道你的表的具体情况,我举例说明哈:
--创建测试表
create table tb12
(id int identity(1,1) not null,
zl int null,
yf decimal(8,2) null
)
go
--添加测试数据
insert into tb12
select 80,null
union all
select 105,null
union all
select 5000,null
union all
select 6000,null
go
select * from tb12
----------------------------------
id zl yf
----------- ----------- ----------
1 80 NULL
2 105 NULL
3 5000 NULL
4 6000 NULL
(所影响的行数为 4 行)
--drop FUNCTION funShipFee
--创建计算邮费的内嵌表值函数funShipFee
CREATE FUNCTION funShipFee()
RETURNS TABLE
AS
RETURN (SELECT id,zl,yf=
case when zl