Feature Request: Generate Procedure Stub

Provides intelligent code completion for SQL Server editors.

Feature Request: Generate Procedure Stub

Postby crutledge » Fri Oct 11, 2013 2:47 pm

When I'm working in Visual Studio, I'll often write calls to functions I haven't written yet. I know what I want the name, inputs and outputs to be, but I haven't gotten around to writing the actual function. If I have a call to a non-existent function in VS, I can right-click the missing function and select 'Generate Method Stub'. VS then creates the basic syntax of the function with the correct input and output variable types.

It would be great if SQL Prompt did something similar. If I'm in a SQL script and I write 'EXEC NonExistentProcedure @Param1=1, @Param2=2', that procedure is underlined with a squiggly red line because it doesn't exist. But since I'm using the 'EXEC' syntax, we know it's going to be a stored procedure with that name (unless I just misspelled an existing procedure). And we know it will have at least 2 parameters name @Param1 and @Param2.

It would be great if I could right-click that underlined procedure name and SQL Prompt would give me the option to generate a CREATE PROCEDURE script for a procedure called NonExistentProcedure and 2 parameters (@Param1 and @Param2).

It would be extra special cool if it could derive the datatype from the value being passed to the non-existent parameter, but I would be happy with just a datatype placeholder.


Chris Rutledge
Posts: 6
Joined: Mon Oct 11, 2010 8:22 pm

Postby Anu Deshpande » Mon Oct 14, 2013 9:31 am

Many thanks for your post and we appreciate the requirement specified by you.

Please feel free to add your vote or if there is one already kindly vote for it:

http://redgate.uservoice.com/forums/944 ... uggestions

And then the project manager can directly decide what category this requirement comes under?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
Posts: 839
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Return to SQL Prompt

Who is online

Users browsing this forum: No registered users and 0 guests