ApexSQL Edit 2011.02
pexSQL Edit is an SQL Server code editor with advanced SQL formatting, refactoring and autocomplete functions. Edit SQL using code snippets, templates and more. Translate SQL code into a variety of programming languages. Encapsulate lengthy blocks of code as database objects. Auto-complete SQL code fragments and constructs. Leverage pre-written code snippets and templates to avoid writing frequently used code over and over.
Develop faster with SQL code auto-complete, snippets and tags
Integrate seamlessly with any source control system
Improve your SQL code with formatting and refactoring
Performance profile your SQL at the line level
Features:
- Improved performance
- SQL Server 2012 support
- Enhanced auto-complete
- Auto-complete pick list
- Auto-complete object details
- Improved formatting engine
- Version-aware editing
- Syntax highlighting
- Improved object search
- Find unused variables and parameters (code refactor)
- Encapsulate as view (code refactor)
- Change parameters (code refactor)
- Replace one-to-many relationships with associative tables (code refactor)
- Add surrogate key (code refactor)
- Additional support for SQL 2008 and SQL 2005 object types
- Advanced SQL formatting
- Native support for the most popular source control providers
- Support for all MSSCCI compliant versioning systems
- SQL templates
- Snippets
- Auto-replacements
- Visual query builder
- SQL debugging
- Code profiler
- Expand wildcards
- Qualify object names
- Copy SQL code as
- Encapsulate as (code refactor)
- Smart rename (code refactor)
- Object search
- Text search
- Graphical dependencies
- Customizable shortcuts
- Transparent decryption
- Support for all SQL Server versions
