IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'dd_FL'
AND type = 'P')
DROP PROCEDURE dd_FL
GO
CREATE PROCEDURE dd_FL
-- dd_FL 'POP00101'
@Tablename varchar(50)
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
declare @FieldList as varchar(max)
select @FieldList = coalesce(@FieldList + ',','') + rtrim(c.COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS c
WHERE c.TABLE_NAME = @Tablename
ORDER BY c.ORDINAL_POSITION
SELECT @FieldList
GO
grant exec on dd_FL to public