存储过程解决参数top问题

方法一:
create procedure test
@top int
as
select top(@top) * from Table1

方法二:
create procedure test
@top int
as
set rowcount @top;
select * from Table1
set rowcount 0;

方法三:拼字符串(太垃圾)

posted @ 2018-10-09 11:53  skybirdzw  阅读(294)  评论(0)    收藏  举报