I'm working with VS2005, and SSMS 2005.
SQL Server allows nested comments as follows:
/* Comment 1
/* Comment 2 */
Some commented out code here
*/
This code runs fine. However if putting the above into a .sql file in VS2005, it incorrectly shows the commented out code as 'active', (its not green). It seems that StackOverflow has highlighted the code in the same way.
Is this a bug in VS2005? Or does SSMS handle nested comments differently compared to the ANSI SQL standards?
Can someone clarify this discrepancy, and if it appears to be a bug, if there a way to fix the syntax highlighting?