Geek asks and answers

Is there an intuitive way to modify and save a stored procedure in VS 2012

The only way I can define in VS 2012 to open an existing stored procedure to modify and save changes is as follows:

1) Manually delete the start word CREATEand re-enter ALTERin its place (each time).

2) In the "SQL" menu, then in the "Transact-SQL Editor" submenu, select Execute.

Given that VS2012 is in Release Candidate, I am sure that there will be no fundamental changes in these lines.

And I understand that from a purist point of view that this executes a request to change the procedure on the server. But in terms of usability, is there no longer an almost equivalent simple button Saveon the toolbar? During the day, this is not a waste of time and mental attention. I could live with Ctrl+ Shift+ E, but the manual editing CREATEto ALTERevery time funny.

+5
source share
2 answers

I assume that you are trying to apply changes to a stored procedure in your database?

: " SQL Server". SQL Server node . , . , CREATE script . CREATE "". "" script " " , script script.

ALTER, Server Explorer ( SQL Server, "" ). Data Connections. , "".

+6

, , , . , :

SSDT TechEd 2012

0

More articles:


All Articles