Within SQL Management Studio, you can right click on a stored procedure and have it generate code to execute that procedure (either into the clipboard or a new query window).  You can also have it generate code to select, insert, delete, and update from a table.

Does this functionality exist in SQLDBControl?  This is a nice time saving function.  Instead of typing it from scratch, I can have the system do it for me (it makes much less mistakes that I do).

Thanks.

Currently it isn't possible to copy a stored procedure into the clipboard without first opening that stored procedure in an editor.  However, this shouldn't be too difficult to add so we'll try and add it for the next release.

Likewise there isn't any way that you can generate a basic code template for select, insert, delete and update statements.  Again this shouldn't be too difficult to add if we're just talking about a basic generic template, however if you wanted a template that was specific to a certain table (i.e. it includes that table's columns) then that would still be possible but a little harder to code for.

---

SQLDBcontrol Support

support@sqldbcontrol.com

Just to clarify, it's not about coping the contents of the store procedure, it's about generating code to execute the stored procedure from another script.  For example...

declare @rc as int

decalre @arg1 as varchar(10)

decalre @arg2 as varchar(10)

set @arg1 = '???'

set @arg2 = '???'

execute @rc = usp_mystoredproc @arg1,@arg2

The second part of the question would be specific to a table (including column names).  It would be a nice timesaver (you know how lazy programmers can be :) ).

Oh OK, I see.  That should be possible.  I'll see if we can work that into the next release.

---

SQLDBcontrol Support

support@sqldbcontrol.com