CREATE PROCEDURE GetRecord @A int AS
declare @b varchar(1000)
set @b='select top '+cast(@A as varchar(10))+' from #pro_sort_dir order by pro_id desc'
exec(@b)
declare @b varchar(1000)
set @b='select top '+cast(@A as varchar(10))+' from #pro_sort_dir order by pro_id desc'
exec(@b)
declare @b varchar(1000)
set @b='select top '+ @a +' * from #pro_sort_dir order by pro_id desc'
exec (@b)