CREATE PROCEDURE [dbo].[GetList](@TableName NVARCHAR(200),@Fild NVARCHAR(200),@Sort NVARCHAR(200))
AS
declare @SQL nvarchar(max);
SET @SQL = 'SELECT * FROM '+@TableName+' ORDER BY '+@Fild+' '+@Sort+' ';
exec sp_executesql @SQL
EXEC [dbo].[GetList] N'B_Categories', N'CategoryName',N'Desc'
