我需要把一个别名,作为一个变量,但是这样写提示不对,请问该怎么写?CREATE PROCEDURE aa
@a int
AS
select AA as a,BB as b,CC as c from aa where order by @a desc
GO
execute aa a
execute aa b
execute aa c
@a int
AS
select AA as a,BB as b,CC as c from aa where order by @a desc
GO
execute aa a
execute aa b
execute aa c
解决方案 »
- 挑战一下~看看这条SQL应该怎么写
- 如何通过COMMAND对象的参数把BINARY类型的数据保存到数据库中?
- 改ttserver源码实现主从模式
- delphi7+sql server 2005 com+不能设置事务
- 请问sqlserver中有没有像oracle rownum一样功能的关键字
- inner join时的问题
- 在SQLserver中,怎么把多行数值加起来给另外一行?
- SQL的安装问题
- 这个问题怎么办???
- 存储过程调用远程联接,并更新数据,数据类型有text等大类型的字段,急谢谢,分不够再加!!在线
- Access数据库中的数据导入Sql Server 2005
- 如何修改数据库中的日期
@a varchar(10)
AS
exec('select AA as a,BB as b,CC as c from aa where order by '+@a+' desc')
GO
execute aa 'a'
@a int
AS
declare @s varchar(1000)
set @s='select AA as a,BB as b,CC as c from aa where order by '+@a+' desc'
exec(@s)
GO