SQL Prompt Standard - Summary

by Red Gate Software - Product Type: Application

Summary

SQL Prompt Standard by Red Gate Software

URLs: red-gate-sql-prompt-standard, red gate sql prompt standard, redgatesqlpromptstandard, red-gate, red gate, redgate

Intelligent code completion and layout for MS SQL Server. SQL Prompt automates the retrieval of database object names, syntax, and snippets as you write, intelligently offering only appropriate code choices. Automatic script layout provides easy code readability – particularly useful when working with unfamiliar scripts. SQL Prompt is highly productive straight out of the box. It is also customizable so you can make it perform exactly the way you want it to. Using SQL Prompt will improve your productivity and dramatically reduce your time at the keyboard.

SQL Prompt

Write SQL fast and accurately with code completion

Understand code more easily with script layout

Continue to use your current editor – SQL Prompt works within SSMS, Query Analyzer, and Visual Studio

Keyword formatting, join completion, code snippets, and many more powerful features

SQL Prompt simply sits behind the scenes and provides unobtrusive help when you press CTRL+SPACEBAR or when you type "." after a table/view/alias name.

SQL Prompt Pro - Intelligent code completion for SQL Server plus layout for easy code readability.

SQL Prompt Standard - Intelligent code completion for SQL Server.

SQL Prompt works with Visual Studio 2005 and 2008, Query Analyzer, SQL Server Management Studio 2005 and 2008, and SSMS Express Edition.

Feature list

Table/View/Column/Sproc name completion

Layout makes scripts easy to read

JOIN/JOIN ON syntax completion

Expand wildcard to column names list

Object creation-SQL viewing pane

Mouse-over tool tips that give object definitions including a useful summary

Parameter hinting for user-defined functions

Cross-database queries

Distributed queries with linked SQL Server instances

Scripted objects included in candidate list

Cursors, cursor variables, and related statements

Auto-uppercasing of keywords and pop-up after keywords

Column selector screen, plus qualify object/column names option

FeatureStandardProSupported for Visual Studio

Code completion•••

Instant access to schema information•••

SQL snippets•••

Statement expansion•••

Find invalid objects••

Search••

Column dependencies•••

Auto-generation of aliases•••

Script as ALTER from query window••

Wildcard expansion - single instance•••

Wildcard expansion - entire script ••

Format SQL •

Decrypt encrypted objects •

Summarize scripts •

Find unused variables and parameters •

Qualify object names •

Smart rename •

Split table •

Encapsulate as stored procedure •

Uppercase keywords •

What's New in SQL Prompt Pro V5.0

SQL Prompt 5 includes a number of significant new features:

Find Invalid Objects - SQL Prompt 5 enables you to easily find invalid objects in your database. This can be useful, for example, if you have inherited a legacy database and you want to know if objects are referencing other objects that no longer exist in the database.

Script Object as ALTER from a query window - If you are navigating a query that contains a reference to an object, SQL Prompt 5 enables you to script out that object directly from the query window by pressing F12.

View column dependencies - SQL Prompt 5 enables you to view a list of objects that reference a column.

SQL Refactor functionality - SQL Refactor has been retired with the release of SQL Prompt 5. Much of the functionality of SQL Refactor is now available in SQL Prompt Professional Edition, including the following:

Smart Rename

Qualify Object Names

Expand Wildcards

Split Table

Encapsulate as New Stored Procedure

Find Unused Variables and Parameters

Summarize Script

SQL Prompt 4 Release notes

Enhanced user interface

The user interface for intellisense suggestions and object definitions has been redesigned to be less intrusive and to make SQL Prompt's features more easily discoverable.

The Options dialog box has also been completely reinvented, with better navigation and a rationalised set of options.

Improved SQL Grammar support

Enhanced T-SQL grammar support for SQL 2000, SQL 2005 and SQL 2008 SQL server editions. Suggestions are more accurate and reliable, and cover a more extensive scope of T-SQL.

Performance improvements

SQL Prompt 4 caches database objects dramatically faster than SQL Prompt 3, and does so much more quickly across high latency networks.

Snippet enhancements

Snippets are now stored as separate files, and so can be easily shared among other SQL Prompt users.

There is a new, separate interface for creating and managing your snippets, including an option to go to the folder where snippets are stored.

Column picker

The column picker has been radically improved, so that it is simpler to find and use, for example it is now clearly labelled, and shows the number of columns currently selected.

Options

Many SQL Prompt 3 options have been removed and replaced with sensible defaults, to simplify the configuration and make more intuitive behavior. The Options dialog box itself has been drastically re-engineered so that it is much quicker to find the option you want, understand its purpose, and preview its effect.

Right-click context menus

Right-click context menus have been implemented inside your query editor for creating SQL Prompt snippets and applying your preferred formatting to code.

Temporary storage only of database objects on disk

Database objects are only cached during your current session. When closing down your query editor, the SQL Prompt object cache is emptied, to save disk space. Offline mode working is therefore no longer supported.

Format styles (Pro feature)

Styles allow you to save and share your format options with other SQL Prompt users.

Decrypts encrypted objects: (Pro feature)

SQL Prompt 4 can now decrypt encrypted objects from SQL 2000, SQL 2005 and SQL 2008 to allow you to view their creation script.

Importing snippets and aliases

As a major new installation, existing user-created snippets and aliases or your old configuration options will not automatically be imported into v4. Red Gate offers two free tools that help migrate snippets and aliases from v3.9, Snippet migrator and Alias importer.

Installing SQL Prompt 4 will disable SQL Prompt 3 and start a new trial period. If you wish to re-enable SQL Prompt 3 you will need to uninstall SQL Prompt 4. If you have user-defined aliases or snippets in SQL Prompt 3 which you wish to retain, we have a migration tool available.

Intelligent code completion and layout for MS SQL Server.

Pricing: SQL Prompt Standard 5.2 1 User License, SQL Prompt Standard 5.2 5 User License, SQL Prompt Standard 5.2 10 User License, SQL Prompt Standard 5.2 with 12 Months of Support and Upgrades 1 User License, SQL Prompt Standard 5.2 with 12 Months of Support and Upgrades 5 User License, SQL Prompt Standard 5.2 with 12 Months of Support and Upgrades 10 User License, SQL Prompt Standard 5.2 with 24 Months of Support and Upgrades 1 User License, SQL Prompt Standard 5.2 with 24 Months of Support and Upgrades 5 User License, SQL Prompt Standard 5.2 with 24 Months of Support and Upgrades 10 User License, SQL Prompt Standard 5.2 with 36 Months of Support and Upgrades 1 User License, SQL Prompt Standard 5.2 with 36 Months of Support and Upgrades 5 User License, SQL Prompt Standard 5.2 with 36 Months of Support and Upgrades 10 User License, SQL Prompt Standard 5.2 Renewal License - 12 Months of Support and Upgrades 1 User Renewal License, SQL Prompt Standard 5.2 Renewal License - 12 Months of Support and Upgrades 5 User Renewal License, SQL Prompt Standard 5.2 Renewal License - 12 Months of Support and Upgrades 10 User Renewal License, SQL Prompt Standard 5.2 Renewal License - 24 Months of Support and Upgrades 1 User Renewal License, SQL Prompt Standard 5.2 Renewal License - 24 Months of Support and Upgrades 5 User Renewal License, SQL Prompt Standard 5.2 Renewal License - 24 Months of Support and Upgrades 10 User Renewal License, SQL Prompt Standard 5.2 Renewal License - 36 Months of Support and Upgrades 1 User Renewal License, SQL Prompt Standard 5.2 Renewal License - 36 Months of Support and Upgrades 5 User Renewal License, SQL Prompt Standard 5.2 Renewal License - 36 Months of Support and Upgrades 10 User Renewal License

Evals & Downloads: Read the SQL Prompt help file, Read the SQL Prompt Data sheet, Read the Red Gate End User License Agreement, Download the SQL Toolbelt evaluation on to your computer - Expires after 14 days

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Application

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server 2000

Keywords: sql prompt standard, sql prompt std, sqlprompt standard, sqlprompt std

Red Gate Software Red-Gate RedGate

SQL query language

Database DB Management

Database DB Reporting Report reports

Part numbers: PC-518564-429320 518564-429320 PC-518564-429332 518564-429332 PC-518564-429323 518564-429323 PC-518564-429326 518564-429326 PC-518564-429335 518564-429335 PC-518564-429329 518564-429329 PC-518564-429338 518564-429338 PC-518564-429339 518564-429339 PC-518564-429340 518564-429340 PC-518564-429341 518564-429341 PC-518564-429342 518564-429342 PC-518564-429343 518564-429343 PC-518564-429344 518564-429344 PC-518564-429345 518564-429345 PC-518564-429346 518564-429346 PC-518564-429347 518564-429347 PC-518564-429348 518564-429348 PC-518564-429349 518564-429349 PC-518564-429350 518564-429350 PC-518564-429351 518564-429351 PC-518564-429352 518564-429352

Mfr. Part No: P53U10M0 P53U10M12 P53U10M24 P53U10M36 P53U1M0 P53U1M12 P53U1M24 P53U1M36 P53U5M0 P53U5M12 P53U5M24 P53U5M36