VS2005 SQL Syntax highlighting is incorrect for nested comments?

Posted by MattH on Stack Overflow See other posts from Stack Overflow or by MattH
Published on 2010-05-18T12:28:06Z Indexed on 2010/05/18 12:30 UTC
Read the original article Hit count: 240

Filed under:

vs2005

|

ssms-2005

|

syntax-highlighting

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?

© Stack Overflow or respective owner

Related posts about vs2005

Simple ‘In-Progress’ Message for Time Consuming Tasks in ASP.NET Pages

as seen on Code Project - Search for 'Code Project'
‘In-Progress’ Message & Disabling controls in ASP.NET Pages using JavaScript >>> More
HTTP Push from SQL Server — Comet SQL

as seen on Code Project - Search for 'Code Project'
Article provides example solution for presenting data in "real-time" from Microsoft SQL Server in HTML browser. Article presents how to implement Comet functionality in ASP.NET and how to connect Comet with Query Notification from SQL Server. >>> More
Store and forward GPS data for Smart Phones

as seen on Code Project - Search for 'Code Project'
How to deliver GPS data asynchronously to the server over the internet without queues. >>> More
Callback Contract in WCF

as seen on Code Project - Search for 'Code Project'
Callback contracts are a very powerful concept that is easily implemented in WCF. Using this, it is very easy to achieve event-like behavior between a service and client (duplex operations). >>> More
Unable to install VS2005 redist @W7 64bit

as seen on Super User - Search for 'Super User'
Hi there, I am struggling with installing VS2005 64/x86 redistributable for W7 64bit: During install it displays an error: Error 1935: An error occured during the installation of assembly 'Microsoft.VC90.ATL, version 9.0.30729.1,publicKeyToken="1fc8b3b9a1e18e3b", processorArchitecture="amd64"… >>> More

Related posts about ssms-2005

VS2005 SQL Syntax highlighting is incorrect for nested comments?

as seen on Stack Overflow - Search for 'Stack Overflow'
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)… >>> More
Option To AutoFormat Query Syntax in SSMS 2005 or 2008?

as seen on Stack Overflow - Search for 'Stack Overflow'
In TOAD (for SQL or Oracle), there is a simple AUTOFORMAT button that will nicely format your query - I couldn't find that option in SSMS 2005, but was advised by a co-worker that it was available in SSMS 2008. I am unable to locate the option there either. This is VERY helpful when pasting a query… >>> More
Rename database data file in SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to rename a databases data file. Is this possible through SQL Server Management Studio? FYI, I do not have permissions to the underlying box. Edit: I also need to change the location of the file. >>> More
SSMS Results to Grid - CRLF not preserved in copy/paste - any better techniques?

as seen on Stack Overflow - Search for 'Stack Overflow'
When I have a result set in the grid like: SELECT 'line 1 line 2 line 3' or SELECT 'line 1' + CHAR(13) + CHAR(10) + 'line 2' + CHAR(13) + CHAR(10) + 'line 3' With embedded CRLF, the display in the grid appears to replace them with spaces (I guess so that they will display all the data). The… >>> More
can i expose SSMS 2005 Schema Change Report in sharepoint?

as seen on Stack Overflow - Search for 'Stack Overflow'
a schema change was made on a production server that generates feeds to our parters, removing two bytes from a field, which clobbered our partner's jobs. my boss wants a notification mechanism to propagate schema changes to everyone, but instead of writing something, id like to get the schema change… >>> More