![red gate sql prompt red gate sql prompt](https://cdn.rd.gt/assets/products/sql-prompt/images/find-unused-small.png)
They understand that elegance and usefulness do not require complicated technical features. Youll receive an email from Redgate asking you to verify your Redgate ID. If the email address you have entered is not already associated with a Redgate ID, youll be presented with the option Create Redgate ID. I am always pleasantly surprised with the power of the features that they are developing. Go to the Redgate ID log in page and enter your email address. SQL Prompt’s feature appears to be incremental and provides a progress bar. With the normal method, there is no acknowledgement of the paste being in progress and I have seen Excel crash during the process. Also, SQL Prompt handles large exports to Excel much better than the copy/paste method. We can thank Buck Woody, and SSMS 2008, for making the results grid copy natively into a format which works well for Excel but now we can thank Redgate for short circuiting the entire process and jumping straight to the end result. Excel tends to be the preferred delivery mechanism for these types of result sets. I cannot count how many times I have been asked to run ad hoc queries in production and send results back to the requester. Get the latest product news, best practices, and training delivered straight to your inbox.
![red gate sql prompt red gate sql prompt](http://contentlasopa565.weebly.com/uploads/1/2/5/4/125498483/150126387.png)
Last but far from least, the Open in Excel feature is my absolute favorite. SQL Prompt delivers a direct conversion from values to IN clause. Now I do not have to worry about copying/pasting the values and making changes. SSMS can also be used but I find Notepad++’s find/replace features better.
![red gate sql prompt red gate sql prompt](https://us.v-cdn.net/6029854/uploads/editor/oj/zyuem0t1cisu.png)
Normally I would use a text editor such as Notepad++ to reformat the multiple lines of values. Copy as IN clauseĮven more common than scripting out INSERT statements, I may need to copy a set of values and format them for an IN clause. This will script out a temporary table and the associated INSERT statement for the values selected. Script to Insertīy selecting rows from the results grid, you can right-click and selection Script as INSERT. The usefulness of these features is incredible. Recently I discovered a couple of new features for the SQL Server Management Studio results grid.
Red gate sql prompt code#
SQL Prompt Core is a free extension for Visual Studio Enterprise, which improves your productivity with advanced IntelliSense-style SQL code completion.
Red gate sql prompt upgrade#
For other versions of Visual Studio, and for new features and support, upgrade to SQL Prompt Pro. Most of all, I love SQL Prompt because its features increase my productivity on a daily basis. Redgate SQL Prompt Core is only available in Visual Studio Enterprise 2017.