在sql server 2005中
select @var=column1 from table1与select top 1 column1 from table1的区别
我在此模型的select语句中有一个列的视图有一个问题
select column0, fn(column0) as col from table2
该fn返回select @var=column1 from table1 where table1.column3=@inputid
我把它换成这个
select
column0,
(select top 1 column1 from table1 wher