昨天做项目时,要求传入一个参数, 选择前几条数据, 两种方法都可以。
create proc topproc
@num int
as
exec('select top '+@num+' * from table')
exec('select top ' + cast(@num as varchar(100)) + ' * from table')
昨天做项目时,要求传入一个参数, 选择前几条数据, 两种方法都可以。
create proc topproc
@num int
as
exec('select top '+@num+' * from table')
exec('select top ' + cast(@num as varchar(100)) + ' * from table')