Provides intelligent code completion for SQL Server editors.
Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law
I have a piece of code with a ton of headers, including the initial "if exists drop" and a sample call.
If I type "exec myprocnamehere", the box pops up with the actual script text. I can then click in the box, hit "copy", and paste in a window.
If I type ALTER PROCEDURE myprocnamehere, then hit TAB, the SP scripts otu - but only starting at the actual ALTER PROCEDURE line, it doesn't include the header! So if I execute it, I'd lose my script headers.
Is there a way to change the behavior? Is there an easier way to script out the object (either way is tons easier than SSMS, but I'd moved to AP (tab) code (tab) and use the snippets to quickly script out the code.
- Posts: 14
- Joined: Thu Sep 14, 2006 4:46 pm
Would it be possible for you to post a very basic example of a stored proc and what you’d expect to happen?
- Posts: 262
- Joined: Fri Jun 28, 2013 10:56 am
- Location: Red Gate Software
I am having the same problem. I am currently using v22.214.171.124 (restruction by IT Security for now.)
When typeing EXEC usp_SOMETHING the popup allows me to select the stored proc code which includes the parts above the ALTER statement which in my case contains important stored procedure header detail and modification tracking information.
When using the ALTER PROCEDURE usp_SOMETHING (or AP[TAB] snippet) and pressing tab after the procedure name the content that appears does not include the parts above the ALTER statement.
- Posts: 1
- Joined: Tue Oct 29, 2013 3:53 pm
Return to SQL Prompt 5
Who is online
Users browsing this forum: No registered users and 0 guests