SQL Server freebie: PromptSQL for word completion

The tool described here is free only for a 30-day evaluation.

Experts typically use Query Analyzer or a dedicated development product to do work in SQL Server, but they must contend with Query Analyzer's many little limitations as a result.

For instance, QA's interface is not interactive: If you try to build a SQL statement that refers to a particular table, the program doesn't prompt you with information about existing columns in the table. But there is one tool that can help make your programming simpler.

PromptSQL is an add-on application that provides auto-complete functionality as you type for programs used to create SQL statements. It works with QA, UltraEdit32, Visual Studio.NET 2003, Visual Studio 2005 and SQL Server 2000 Enterprise Manager.

The program's auto-complete functionality is contextual, based on what you're typing at that moment. For instance, if you're...

RELATED CONTENT SQL Server Stored Procedures SQL Server Mailbag: CALs, witnesses and unwanted changes SQL Server Mailbag: Stored procedures, triggers and SSRS reports Top tips and tricks for SQL Server database development Top 10 SQL Server development tips of 2008 SQL Server trigger vs. stored procedure to receive data notification SQL Server errors, failures and other problems fixed from the trenches SQL Server and data manipulation in T-SQL How to use SQL Server 2008 hierarchyid data type SQL Server stored procedures tutorial: Write, tune and get examples Check SQL Server database and log file size with this stored procedure SQL/Transact SQL (T-SQL) Combining result sets from multiple SQL Server queries Using DELETE and TRUNCATE TABLE statements to delete data in SQL Server SQL language crash course (just enough to be dangerous) Working with IntelliSense in SQL Server 2008 Management Studio SQL Server Mailbag: Stored procedures, triggers and SSRS reports Working with sparse columns in SQL Server 2008 Determining the source of full transaction logs in SQL Server New GROUP BY option provides better data control in SQL Server 2008 Using the OPENROWSET function in SQL Server Loading data files with SQL Server's BULK INSERT statement SQL/Transact SQL (T-SQL) Research Database Management and Administration Database encryption in SQL Server 2008: Improvements you finally need Common oversights with SQL Server security audits Top 5 SQL Server DBA tasks that are a waste of time Password cracking tools for SQL Server Using traces in SQL Server Profiler Meet compliance requirements with improved database security practices Hardening the network and OS for SQL Server security Securing the server and database in SQL Server How SQL Server 2008 components impact SharePoint implementations Troubleshooting Distributed Transaction Coordinator errors in SQL Server

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary library  (SearchSQLServer.com) trigger  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

logged into a given database in QA and you type EXEC, PromptSQL prompts you with a list of stored procedures for that database, which you can then narrow down by typing further. Likewise, if you're composing a SELECT statement, the program can prompt you for the names of columns, tables, databases and even suggest JOINs. Note that JOIN functionality only works if you have table relationships explicitly defined in your database. Also, if you have more than one FROM in the current SQL statement, only the first FROM is considered for any kind of processing.

This functionality also extends to other objects. If you have a stored procedure with variables, typing the @ character will produce a list of all variables for the current stored procedure. Ditto for temporary tables: If you type #, a list of temporary tables for the currently-used database comes up. Typing @@ brings up a list of SQL Server objects, such as @@ERROR or @@CONNECTIONS.

There are other features to make programming simpler. When you point to the name of a table in one of the program's selection lists, a tooltip pops up with a description of all the table's objects and their defaults.

The program can be downloaded and evaluated free for 30 days. A single seat license is $25; volume discounts are available, too.

About the author: Serdar Yegulalp is editor of the Windows Power Users Newsletter. Check it out for the latest advice and musings on the world of Windows network administrators -- and please share your thoughts as well!

More information from SearchSQLServer.com