select top 5 * from student
alter procedure selectTopN
@count int
as
begin
declare @topCount varchar(1000)
set @topCount='select top '+convert(varchar,@count)+' * from student'
exec(@topCount)
end
exec selectTopN 10
select top 5 * from student
alter procedure selectTopN
@count int
as
begin
declare @topCount varchar(1000)
set @topCount='select top '+convert(varchar,@count)+' * from student'
exec(@topCount)
end
exec selectTopN 10