Check if Column Exists in Database Table in SQL Server

NerakSev...

SOLVED CLOSED ACTIVE ANSWERED
User: NerakSeven
Posted: on Dec 10, 2018 10:32 PM
Forum: SQL Server
Answer: 1
Views: 3097

I have a dynamic sql that works fine when the name of the columns exists, how can I make it not send error if the column does not exist

DECLARE @codigo NVARCHAR(200) 
DECLARE @column NVARCHAR(200)
SET @codigo = '110201'
SET @column = '[1]'
DECLARE @sqlQuery NVARCHAR(MAX);
SET @sqlQuery = N'SELECT '+ @column + ' FROM Codigo_Obra_Tipo_Actividad WHERE ' + @column + ' = ''' + @codigo + ''''
EXEC (@sqlQuery)

pandeyis...

0 3

Reply
ANSWER
User: pandeyism
Replied: on Dec 11, 2018 05:36 AM
Report

Hey NerakSeven,

Please refer below query.

SQL

CREATE TABLE TesCode(A1 VARCHAR(200))
INSERT INTO TesCode VALUES('110201')
DECLARE @codigo NVARCHAR(200)
DECLARE @column NVARCHAR(200)
SET @codigo = '110201'
SET @column = 'A1'
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TesCode' AND COLUMN_NAME = @column)
BEGIN
	DECLARE @sqlQuery NVARCHAR(MAX);
	SET @sqlQuery = N'SELECT '+ @column + ' FROM TesCode WHERE ' + @column + ' = ''' + @codigo + ''''
	EXEC (@sqlQuery)
END

Check if Column Exists in Database Table in SQL Server

Company

Explore

Follow us

Contact Us