t-sql 如何在查询中给变量赋值

select dwdm,@wfhyy=(
case
when getdate()-zncsrq<=90 then '期 内'
when zfmz<>'01' or fnmz<>'01' then ' 少数民族'
end ) from qhry

参考思路：
把查询结果绑到DataTable，然后在DataTable里取出来赋值，
参考例如如下：
create proc minus
@year1 int,
@month1 int
@year2 int,
@month2 int
as
declare @num1 int
declare @sql1 nvarchar(2000)
set @sql1 ='select @num1=A from table where years=' + cast(@year1 as nvarchar(20))+ 'and month=' + cast(@month1 as nvarchar(20))
exec(@sql1)

declare @num2 int
declare @sql2 nvarchar(2000)
set @sql2 ='select @num2=A from table where years=' + cast(@year2 as nvarchar(20))+ 'and month=' + cast(@month2 as nvarchar(20))
exec(@sql2)

select (@num1-@num2) as number

选择语句的哦！