SQL Prompt is one of my favorite utilities when working with SQL Server and RedGate just released SQL Prompt 4.0. If you have not used a tool like SQL Prompt to help you with code completion of SQL Queries and Stored Procedures, code beautification ( formatting ) to make T-SQL easier to read and maintain, and productivity, you might want to give the free trial a whirl.
Per the Red Gate website, SQL Prompt has the following features:
- Code completion: SQL Prompt provides comprehensive code completion, with support for all non-CLR SQL syntax, and automatically suggests appropriate join conditions.
- Instant access to schema information: See the schema details for objects in the suggestion list, and hover over objects in your script to see their schema definition and documentation.
- Wildcard expansion and column picker: Expand SELECT * to a complete list of columns with a single keypress, or use the column picker to quickly insert the list of columns you need.
- SQL snippets: Create snippets to insert fragments of SQL you use regularly. For example instead of typing SELECT * FROM with SQL Prompt you can just type ssf
- Statement expansion: SQL Prompt automatically completes INSERT statements with a list of column names and values, ALTER PROCEDURE statements with the procedure definition, and more.
- SQL formatting: Automatically fix the formatting of any SQL code you have to maintain. Formatting rules are configurable to match your preferred coding style.
- On-the-fly schema decryption: For databases where you have permission, SQL Prompt locally decrypts encrypted views and stored procedures and shows you their definitions.
Cool Stuff. Learn more on the Red Gate website.
Tagged: SQL Server Tutorials and Utilities, .NET Developer Tools, Code Generators and Code Generation
David Hayden