存储过程中这一段定义了两个变量declare @cfnu int,@dznu用SELECT cfnu, dznu FROM AEstart WHERE (dm = @dm)能找到复合条件的2个值，怎

[my_yinger]

存储过程中这一段定义了两个变量declare @cfnu int,@dznu用
SELECT cfnu, dznu FROM AEstart WHERE (dm = @dm)能找到复合条件的2个值，怎么写这个sql语句把SELECT cfnu, dznu找到的2个值赋给@cfnu int,@dznu ？

[dafu71]

declare @cfnu int,@dznu
SELECT @cfnu =cfnu, @dznu=dznu FROM AEstart WHERE (dm = @dm)

[pengdali]

declare @cfnu int,@dznu int
SELECT @cfnu=cfnu,@dznu=dznu FROM AEstart WHERE (dm = @dm)