CREATE procedure AAAA
@n int
AS
declare @SQL varchar(8000)
set @SQL='select top '+cast(@n as varchar(10))+ ' * FROM [table] order by newid()'
EXEC(@SQL)
GO
@n int
AS
declare @SQL varchar(8000)
set @SQL='select top '+cast(@n as varchar(10))+ ' * FROM [table] order by newid()'
EXEC(@SQL)
GO
@n int
AS
EXECUTE('select top ' +@n + ' * FROM cloth order by newid()')
GO