存储过程解决参数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;
方法三:拼字符串(太垃圾)
方法一:
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;
方法三:拼字符串(太垃圾)