Feature Request for Format

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Feature Request for Format

Postby Bill_Ross » Mon Nov 22, 2010 5:30 pm

I recently discovered that Microsoft Sql Server will allow you to create a stored procedure, view, etc, with nested comments, but, once created, will not allow you to retrieve it. For example:


/*
One comment

/*
Nested Comment
/*

End of first comment

*/

Create Proc myproc...


This can result in loss of countless hours of programming.

Can you add a feature to the formatting to flag nested comments?
Bill_Ross
 
Posts: 14
Joined: Mon Mar 22, 2010 6:49 pm

Postby chriskelly » Tue Nov 23, 2010 6:55 pm

Thank you for your suggestion.

I have lodged this with our development team as an Enhancement Request, reference: SP-3605.
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby simon.jackson » Tue Nov 30, 2010 12:54 pm

Bill, It may be worth noting that SQL Prompt will allow you to recover those scripts. In version 4 you can hover over the object name and click the yellow tooltip. The script pane will come up with the complete script.

If you are using the SQL Prompt 5 EAP you can right click on the object name and "Script object as alter", which avoids hitting this (and several other) bugs in SSMS's script object as alter.
simon.jackson
 
Posts: 45
Joined: Thu Jan 08, 2009 10:42 am


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests