declare aaa table (fvalue int)
insert into aaa values (@a)
insert into aaa values (@b)
....
select max(fvalue) from aaa
insert into aaa values (@a)
insert into aaa values (@b)
....
select max(fvalue) from aaa
declare @aaa table (fvalue int)
insert into @aaa values (@a)
insert into @aaa values (@b)
....
select max(fvalue) from @aaa
declare @b int
declare @c intset @a=2
set @b=1
set @c=5select case
when @a>@b then
case
when @a>@c then @a
else @c
end
else
case
when @b>@c then @b
else @c
end
end as maxone
maxone
5不要写“(经搜索,无解)”
是什么意思?每个循环求一次最大值吗?这个是表变量,不是临时表,过程结果自动就释放了,不需要用drop, 你可以在下一次求最大最小时,先delete from @aaa,再做上面的操作。
insert into @aaa values (@a)
insert into @aaa values (@b)
....
select max(fvalue) from @aaa怎么调试用错?
insert into aaa values (1)
insert into aaa values (2)
select max(fvalue) from aaa
在SQL SERVER 7调试提示
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'table'.
SQL SERVER 2000 提示
服务器:消息 156,级别 15,状态 1 行 1
Incorrect syntax near the keyword 'table'.
为什么