AND附近的语法不正确

本文介绍了AND附近的语法不正确的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ 当我执行程序时，我有以下程序。它总是给我错误AND附近的语法不正确。我不知道它有什么问题。我经历了很多次代码，无法找到错误。以下是我的程序：Hi i have the following procedure, when i execute the procedure. it always give me the error "Incorrect syntax near AND". I dont have idea on what is wrong with it. I have gone through many times the codes and cant find what is the error. Below are my procedure:<pre lang="sql">DECLARE @SQL NVARCHAR(MAX)DECLARE @params NVARCHAR(MAX)SELECT @SQL = 'SELECT CustomerName,[0] as Pending, [1] as Save_As_Draft, [2] as Spec_Confirmed, [3] as Request_Revision, [4] as Withdraw, [5] as Pending_RND, [6] as Pending_QC, [7] as Manday_Confirmed, [0]+[1]+[2]+[3]+[4]+[5]+[6]+[7] as TotalFROM( SELECT P.DocStatus,C.CustomerName,P.CustomerID FROM dbo.CRF_Project P INNER JOIN dbo.CustomerList C ON P.CustomerID = C.CustomerID WHERE Year([CreateDate])= '+@YEAR+') pPIVOT( COUNT (CustomerID) FOR DocStatus IN ([0], [1], [2], [3], [4], [5], [6], [7])) AS pvt 'SELECT @params = '@CUSTNAME VARCHAR(MAX), @YEAR VARCHAR(MAX)'IF(@CUSTNAME != '') SELECT @SQL = @SQL + ' AND CustomerName IN (' + @CUSTNAME + ')'ELSE SELECT @SQL = @SQLEXEC sp_executesql @SQL, @params, @CUSTNAME, @YEAREND推荐答案' AND CustomerName IN (' + @CUSTNAME + ')' into' WHERE CustomerName IN (' + @CUSTNAME + ')' ，如as in theSELECT @SQL = @SQL + ' AND CustomerName IN (' + @CUSTNAME + ')' SQL Server将@SQL与后面的新AND语句结合起来。因此，AND语句不会附加在枢轴内的WHERE后面，而是在枢轴p之后。不应使用AND，而应使用WHERE。the SQL Server will combine the @SQL with the new AND statement behind. Therefore the AND statement is not append behind the WHERE inside the pivot but after the pivot p. Instead of using AND, WHERE should be used. 这篇关于AND附近的语法不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！