怎么获取数据

[xzl16843]

我写了个select TrueTel from T_VIRTUALTEL where VirtualTel = '110' and ActiveFlag = 1

怎么获得TrueTel的值啊? 象sss=TrueTel这样.

[lxzm1001]

这不是得到了吗

[turenjie]

declare @str varchar(8000)
select @str = TrueTel from T_VIRTUALTEL where VirtualTel = '110' and ActiveFlag = 1
print @str

[turenjie]

declare @str varchar(8000)
set @str = ''
select @str = ','+TrueTel from T_VIRTUALTEL where VirtualTel = '110' and ActiveFlag = 1
set @str = stuff(@str,1,1,'')
print @str

[OracleRoob]

declare @v varchar(100)

select top 1 @v=TrueTel from T_VIRTUALTEL where VirtualTel = '110' and ActiveFlag = 1

select @v

[dba_sunny]

declare @str varchar(8000)
select @str = TrueTel from T_VIRTUALTEL where VirtualTel = '110' and ActiveFlag = 1
print @str