Database

CREATE PROCEDURE  returncolname @tablename varchar(255),  @colname varchar(255)<br />
<br />
AS<br />
declare @tblname  as varchar(255)<br />
set @tblname = @tablename <br />
declare @clnName  as varchar(255)<br />
set @clnName = @colname<br />
 <br />
 SELECT @clnName AS [Columns] <br />
FROM information_schema.columns <br />
WHERE (TABLE_NAME = @tablename) and (Column_name =@colname )<br />
<br />
GO

CREATE PROCEDURE DynamicSqlTest
(
    @columnName NVARCHAR(100)
)
AS
 
DECLARE @sql NVARCHAR(1000)
 
SET  @sql = 
N'SELECT COLUMN_NAME AS Columns 
  FROM information_schema.columns 
  WHERE (TABLE_NAME = ''MyTable'') and 
  (COLUMN_NAME = ''?COLUMN_NAME?'')'
 
SET @sql = REPLACE(@sql,'?COLUMN_NAME?',@columnName)
 
EXEC(@sql)

Zdenek Navratil wrote:

It doesn't help to set 'enabled' to all of the existing permissions