求教，能否这样提取字段值？如不能，应该如何提取？谢谢

[SRCS000]

create table CRBT_XNYLMT
(
MT_CALLER VARCHAR(20) NOT NULL, --手机号码
MT_SCORE INT , --下载次数
MT_TIME DATETIME DEFAULT GETDATE() NOT NULL --下载时间
)

CREATE PROCEDURE PROC_CRBT_XNYLMT
()
as
begin
@score int
@mttime datetime

SELECT TOP 1 * FROM CRBT_GDSZ_XNYLMT WHERE MT_CALLER=@caller ORDER BY MT_TIME desc
select @RowCountVar =@@RowCount
SELECT @score = MT_SCORE
SELECT @mttime = MT_TIME

报错

Procedure 'PROC_CRBT_XNYL', Invalid column name 'MT_SCORE'.

[华夏小卒]

SELECT TOP 1 @score = MT_SCORE,@mttime = MT_TIME
FROM CRBT_GDSZ_XNYLMT WHERE MT_CALLER=@caller ORDER BY MT_TIME desc  

--select @RowCountVar =@@RowCount 加了top 1，这个值肯定是1，所以加了等于没加

[Sybase数据库恢复]

哪个数据库系统都不能这样的。

[WWWWA]

1、打开游标循环取值；
2、
SELECT TOP 1 MT_SCORE,MT_TIME into @score,@mttime FROM CRBT_GDSZ_XNYLMT WHERE MT_CALLER=@caller ORDER BY MT_TIME desc