Stored Procedures with Comments Above Create Statement

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

Stored Procedures with Comments Above Create Statement

Postby shickox » Wed Oct 30, 2013 10:23 pm

When I type "alter proc " followed by the procedure name SQL Prompt produces an alter proc statement for the named procedure, but I've noticed if the procedure has a comment header above the alter statement the comments are lost. All comments are preserved when they appear after the alter statement.
shickox
 
Posts: 1
Joined: Thu Oct 24, 2013 6:04 pm

Postby Anu Deshpande » Fri Nov 01, 2013 11:01 am

Thanks for your post.

I have logged a support ticket for you and will email you after I have a quick discussion with our product manager.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests

cron