New SQL Prompt™ from Red Gate delivers seamless auto-completion for SQL Server

"Life is too short to remember hundreds of different object names"

CAMBRIDGE, U.K., January 22, 2007 – After nine months of work and thousands of dedicated developer hours, Red Gate Software has launched SQL Prompt 3, a $195 T-SQL auto-completion add-in for Management Studio and Query Analyzer.

SQL Prompt provides the exact formatting that should be used for SQL commands while the user is writing them, enabling faster, perfectly formatted SQL statements.

"We've tried to create a tool with time-saving and accuracy benefits that can be exploited by both SQL Server professionals and those less familiar with T-SQL code," says Bart Read, lead developer for SQL Prompt. "Let's face it; life is too short to remember hundreds of different object names."

Since the free release of SQL Prompt 2, the tool has been subject to a major development overhaul driven by feedback from the thousands of professionals who downloaded the product. SQL Prompt 3 has emerged from Red Gate's relentless testing phase fully compatible with SQL Server 2000 and 2005 and supporting both Management Studio and Query Analyzer. The new tool includes the following features:

  • DML statement auto-completion for SELECT, INSERT, UPDATE, DELETE
  • Aliases
  • Derived tables
  • Sub-queries
  • Joins, self-joins and JOIN condition generation
  • Auto-expansion of wildcard columns and column picker
  • Built-in functions
  • Signature insertion for functions and stored procedures when using EXEC
  • Support for variables, including table-valued variables

"Being used to the customizable IntelliSense of Visual FoxPro, finding a similar tool for SQL Server is great," says Boudewijn Lutgerink, software architect for Lutgerink Economisch.

Brian Brewder, Brian Online, also praises the tool: "If you develop T-SQL scripts, SQL Prompt 3 will greatly improve your productivity. This is a must-have tool for all T-SQL developers."

A fully-functional version of SQL Prompt is available as a free 14-day trial and for direct purchase from www.red-gate.com.

About Red Gate Software

Red Gate Software makes simple tools for Microsoft technology developers and DBAs. The company's product line includes tools for comparing, synchronizing, packaging and backing up SQL Server databases; understanding and fixing .NET code problems; and load-testing .NET web applications. Red Gate is a Microsoft Gold Visual Studio .NET launch partner and a VSIP partner.

###

Product and service names mentioned in this release may be trademarks of their respective owners.

Press Contact: Bob Cramblitt,
Cramblitt & Company
tel. 919-481-4599
info@cramco.com