.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh
Melody Anderson
Eminent IT

Home >> Technology News >> General >> Post New Resource Bookmark and Share   

 Subscribe to Tech News

Red Gate "SQLPrompt_5.1" nice tool

Posted By:shankey       Posted Date: June 08, 2011    Points: 25    Category: General    URL: http://www.dotnetspark.com  

What Can Red Gate SQL Prompt Do?

SQL Prompt performs all of the functions mentioned above in the Microsoft IntelliSense section, and more.

  1. Wildcard Expansion of Columns

    This is similar to the Quick Info feature described above but so much better. Rather than popping up a control tip box with a list of existing columns, SQL Prompt will expand the "star" to an actual list of columns embedded in your SELECT statement. So if I wanted 15 columns out of 20 available in the table, I'd just type SELECT * FROM MyTable, put the cursor at the * and press the TAB button. This action replaces the "*" with the column list, one column name per line.

  2. Column Picker

    The column picker has been around since the beginning and though I haven't used it much, it's a great feature for those who are used to seeing this sort of interface in the SQL Server Query Window. It's basically an alternative to the process described above. Rather than striking TAB to auto-load a list of ALL columns, you simply check off the columns you wish to put in place of the "star". (See screen shot below).

  3. View Schema Information

    When you type in a few letters, a List Members box opens up, as with the SQL Server 2008 tool, but as you highlight an object name, another window flys out with the script for that object. So in one of my databases I'm able to type p_Com in the query window and SQL Prompt opens a list with the proc's full name. Another window then flys out with the script for that proc. I press a COPY button and I can paste the script in the window and work on the proc. (See screen shot below).

    The alternative to this is to execute SP_HELPTEXT with the full name of the proc, highlight the results (if sent to grid because it often doesn't work when sent to text), copy the text with a Ctl+C and then paste it into the query window. Not that many more steps, but if it's something you do 20-30 times a day, you'll notice the difference. (See screen shot below).

  4. Create and Load Snippets

    This is the feature I can't live without and it doesn't exist in SQL Server 2008 Management Studio. SQL Prompt has, from the beginning, supplied a list of "snippets" that may be loaded into the query window by simply typing the first few characters of the snippet name and pressing TAB. SQL Prompt comes preloaded with a number of useful scripts in the Snippet library.

    You can also add your own snippets and they will become available as well. With version 4.0 the management of snippets has changed and they are now saved as files, which may be backed up and shared with others. If another user has a snippet to share, they simply send it to you and you place the snippet file into the default folder for snippets. Voillia . it's now available.

  5. Format SQL Code (pro edition only)

    Another feature I love is the automatic formatting of my SQL code. Call me anal if you must, but I like it when all keywords are capitalized but I don't like to have to reach for the SHIFT key. With this feature, I don't have to, and it's another little thing I miss when using SQL Server 2008 tools. You can also define how you want your SQL statements formatted, where line breaks occur and things like whether to include spaces after commas and on either side of an equals sign. There are many other options settings for line formatting, enough to meet just about anyone's idea of how their T-SQL should look.

  6. Option Settings

    The options settings in SQL Server 2008 are virtually nonexistent compared to what is available in SQL Prompt. You're given the ability to do things like control the list behavior, hide system objects, default column matching on joined tables and many, many more options.

Below are some screen shots of benefits of SQL Prompt described above. There are really so very many options and features, an exhaustive article would be difficult to write and probably boring to read. The full description of what the product does is, of course, at the Red Gate web site:

screen shots of benefits of SQL Prompt

screen shots of benefits of SQL Prompt

 Subscribe to Tech News


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Technology News Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend