SQL中如何将定义的变量作为列 别名 使用

测试数据：

 

create table test
(
value int not null
)

-----drop  table  test

insert into test (value)
select 2
union all
select 3
union all
select 2
union all
select 7
union all
select 6
union all
select 3
union all
select 5
union all
select 6
union all
select 8
union all
select 4
union all
select 9
union all
select 4
union all
select 1
union all
select 2

select  *  from  test

declare @cc int
declare @str varchar(8000)
set @cc=9999

print @cc
set @str='select value as '+'['+cast(@cc as varchar(10))+']'+'from test'
print @str

 

 

测试结果：

 

 

转载于:https://www.cnblogs.com/netsa/archive/2013/04/02/2995142.html