存储过程错误 “列名 'DegreeID' 不明确”或“无法绑定由多个部分组成的标识符 ST.DegreeID”。
如果是DegreeID,则出现“列名 'DegreeID' 不明确”错误
如果是ST.DegreeID 则出现“无法绑定由多个部分组成的标识符 ST.DegreeID”
请高手指点一下,谢谢先~~
SET @Sql = 'SELECT ST.*,ROW_NUMBER() OVER (ORDER BY '+@SortBy+') AS RowID,SB.SubjectName,DE.DegreeName FROM Student ST JOIN Subject SB ON ST.SubjectID=SB.SubjectID JOIN Degree DE ON ST.DegreeID=DE.DegreeID '
SET @SqlCount = 'SELECT @Count=count(*) FROM [dbo].[Student] '
SET @WhereClause = 'WHERE 1=1 '
IF RTrim(@TrueName)<>''
SET @WhereClause = @WhereClause + ' AND [TrueName] like ''%' + @TrueName + '%'''
IF RTrim(@DegreeID)<>'0'
SET @WhereClause = @WhereClause + ' AND [DegreeID] =''' + Cast(@DegreeID AS VARCHAR(30)) + ''''
IF RTrim(@SubjectID)<>'0'
SET @WhereClause = @WhereClause + ' AND [SubjectID] =''' + Cast(@SubjectID AS VARCHAR(30)) + ''''