sql查询给出“无效的列名” [英] sql query gives "invalid column name"

问题描述

这是我的查询：

this is my query:

DECLARE @columns VARCHAR(8000)

SELECT @columns = COALESCE(@columns + ',[' + cast(Date as varchar) + ']',
'[' + cast(Date as varchar)+ ']')
FROM Absence
GROUP BY Date DECLARE @query VARCHAR(8000) SET @query = ' SELECT * FROM (SELECT Name , Code, Section, Date FROM Absence) up PIVOT (COUNT(Code) FOR Date IN (' + @columns + '))  AS p WHERE Section LIKE A ' EXECUTE(@query)

它给出无效的列名'A'

it gives "Invalid column name 'A'"

推荐答案

您已划定<$ c的单引号$ c> LIKE ：

You have delimit a single quote for LIKE:

GROUP BY Date DECLARE @query VARCHAR(8000) SET @query = ' SELECT * FROM (SELECT Name , Code, Section, Date FROM Absence) up PIVOT (COUNT() FOR Date IN (' + @columns + '))  AS p WHERE Section LIKE ''A'' ' EXECUTE(@query)

这篇关于sql查询给出“无效的列名”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！