Activity overview
Latest activity by tulu
Happens while trying to Layout code. Strange thing is, your sample code works well:
SELECT staffId, staffName, grossSalary
FROM [dbo].[personnel]
WHERE ( type = 'm' OR type = 'n'
) AND grossSalary > @minSalary * 2
is translated to:
SELECT staffId,
staffName,
grossSalary
FROM [dbo].[personnel]
WHERE ( type = 'm'
OR type = 'n'
)
AND grossSalary > @minSalary * 2
But my code is marked with all red underlining. (There must be a description for those red underlining somewhere, but I am unable to find it)
The only thing I suspect may be related to system locale, (We use turkish 1254 codepage, and in that code page, uppercase(i) is not I. We have met problems related to that before. / comments
Happens while trying to Layout code. Strange thing is, your sample code works well:
SELECT staffId, staffName, grossSalary
FROM [dbo].[personnel]
WHERE ( type = 'm' OR ty...
BUG?: Syntax Error when using alias
Refactor thinks that the following code has syntax errors:
SELECT DISTINCT S.StudentID
FROM Student S
ORDER BY S.StudentID DESC
If I remove the S alias, everyting works.