{"id":171,"date":"2017-05-08T00:00:00","date_gmt":"2013-01-01T00:00:00","guid":{"rendered":"https:\/\/www.sqlhammer.com\/redgate-sql-prompt-grid-features"},"modified":"2026-03-18T21:52:54","modified_gmt":"2026-03-18T21:52:54","slug":"redgate-sql-prompt-grid-features","status":"publish","type":"post","link":"https:\/\/sqlhammer.com\/index.php\/2017\/05\/08\/redgate-sql-prompt-grid-features\/","title":{"rendered":"Redgate SQL Prompt Grid Features"},"content":{"rendered":"<p>I love Redgate tools. Most of all, I love SQL Prompt because its features increase my productivity on a daily basis. Recently I discovered a couple of new features for the SQL Server Management Studio results grid. The usefulness of these features is incredible.<\/p>\n<h2>Script to Insert<\/h2>\n<p><a href=\"http:\/\/www.sqlhammer.com\/?attachment_id=3655\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/Script-INSERT-demo-1.gif\" alt=\"\" \/><\/a><\/p>\n<p>By selecting rows from the results grid, you can right-click and selection Script as INSERT. This will script out a temporary table and the associated INSERT statement for the values selected.<\/p>\n<h2>Copy as IN clause<\/h2>\n<p><a href=\"http:\/\/www.sqlhammer.com\/?attachment_id=3651\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/Copy-IN-Clause-demo.gif\" alt=\"\" \/><\/a><\/p>\n<p>Even more common than scripting out INSERT statements, I may need to copy a set of values and format them for an IN clause. Normally I would use a text editor such as <a href=\"https:\/\/www.google.com\/url?sa=t&#038;rct=j&#038;q=&#038;esrc=s&#038;source=web&#038;cd=1&#038;cad=rja&#038;uact=8&#038;ved=0ahUKEwjPzejWkdzTAhUh6IMKHfyECX4QFggnMAA&#038;url=https%3A%2F%2Fnotepad-plus-plus.org%2F&#038;usg=AFQjCNExci2YY1gy2cZYcnKLKfl2A9jWCg&#038;sig2=EHJ-ceQXukuuRQO7Rm6LpA\">Notepad++<\/a> to reformat the multiple lines of values. SSMS can also be used but I find Notepad++\u2019s find\/replace features better.<\/p>\n<p>Now I do not have to worry about copying\/pasting the values and making changes. SQL Prompt delivers a direct conversion from values to IN clause.<\/p>\n<h2>Open in Excel<\/h2>\n<p><a href=\"http:\/\/www.sqlhammer.com\/?attachment_id=3652\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/Open-In-Excel-demo.gif\" alt=\"\" \/><\/a><\/p>\n<p>Last but far from least, the Open in Excel feature is my absolute favorite. I cannot count how many times I have been asked to run ad hoc queries in production and send results back to the requester. Excel tends to be the preferred delivery mechanism for these types of result sets.<\/p>\n<p>We can thank <a href=\"http:\/\/buckwoody.com\/\">Buck Woody<\/a>, 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. Also, SQL Prompt handles large exports to Excel much better than the copy\/paste method. With the normal method, there is no acknowledgement of the paste being in progress and I have seen Excel crash during the process. SQL Prompt\u2019s feature appears to be incremental and provides a progress bar.<\/p>\n<h2>Wrap up<\/h2>\n<p>Keep up with Redgate\u2019s product updates. I am always pleasantly surprised with the power of the features that they are developing. They understand that elegance and usefulness do not require complicated technical features. Simple but profound features are what help us DBAs streamline our work days.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I love Redgate tools. Most of all, I love SQL Prompt because its features increase my productivity on a daily basis. Recently I discovered a couple of new features for the SQL Server Management Studio results grid. The usefulness of these features is incredible. Script to Insert By selecting rows from the results grid, you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":562,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3,5,7,9,10,14,15,16],"tags":[],"class_list":["post-171","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tsql2sday","category-administration","category-azure","category-community","category-development","category-disaster-recovery","category-performance","category-powershell","category-sql-agent"],"_links":{"self":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/comments?post=171"}],"version-history":[{"count":1,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/171\/revisions"}],"predecessor-version":[{"id":433,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/171\/revisions\/433"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media\/562"}],"wp:attachment":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media?parent=171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/categories?post=171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/tags?post=171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}