34,590
社区成员
发帖
与我相关
我的任务
分享上次谁告诉我说Sql Server 2005里面TOP后面可以跟变量的???
记得上次提问,有人告诉我说Sql server 2005里面TOP后面可以跟变量
如
declare @num as int
set @num = 10
select top @num * from table
结果我在2005里面一试,还是不行,欺骗我的感情啊~~~~
如
declare @num as int
set @num = 10
select top @num * from table
结果我在2005里面一试,还是不行,欺骗我的感情啊~~~~
...全文
请发表友善的回复…
发表回复
allright_flash 2006-09-28
- 打赏
- 举报
declare @num as int
set @num = 10
select top(@num) * from table
问题解决了，我还在想半天。呵呵
set @num = 10
select top(@num) * from table
问题解决了，我还在想半天。呵呵
pellet 2006-09-28
- 打赏
- 举报
原来加个括号.....囧
谢谢ls
谢谢ls
dawugui 2006-09-28
- 打赏
- 举报
2楼正解,经测试无误.
dawugui 2006-09-28
- 打赏
- 举报
楼上正解,经测试无误.
guanjm 2006-09-28
- 打赏
- 举报
declare @num as int
set @num = 10
select top(@num) * from table
要加()的
set @num = 10
select top(@num) * from table
要加()的
冷箫轻笛 2006-09-28
- 打赏
- 举报
declare @num as int
declare @sql varchar(200)
set @num = 10
set @sql = 'select top '+ cast(@num as char) + ' * from table'
exec(@sql)
declare @sql varchar(200)
set @num = 10
set @sql = 'select top '+ cast(@num as char) + ' * from table'
exec(@sql)
