34,874
社区成员
发帖
与我相关
我的任务
分享sql
想实现status列名随着变量变化
写了如下的存储过程，但是不对，请问如何解决呢？谢谢
create proc ta_pr
@n varchar(20)
as
select fa,status as @n
from ta
写了如下的存储过程，但是不对，请问如何解决呢？谢谢
create proc ta_pr
@n varchar(20)
as
select fa,status as @n
from ta
...全文
请发表友善的回复…
发表回复
victorycyz 2003-12-08
- 打赏
- 举报
exec('select fa,status as ' + @n )
wzh1215 2003-12-08
- 打赏
- 举报
create proc ta_pr
@n varchar(20)
as
exec('select fa,status as '+@n+' from ta')
@n varchar(20)
as
exec('select fa,status as '+@n+' from ta')
