MS SQL Server Editor for SQL and Transact-SQL
The MS SQL Server SQL editor provided by RazorSQL includes features to make MS SQL Server development easier. Users can easily run SQL commands manually or with a click of the mouse, and create, edit, and drop MS SQL Server stored procedures, functions, and triggers. Auto completion and auto lookup functionality are also provided to boost productivity. Listed below are the main features of the MS SQL Server SQL Editor.
RazorSQL also offers many other MS SQL Server tools such as a MS SQL Server database browser, a MS SQL Server table editor, an SQL query builder, GUI tools for managing MS SQL Server objects and structures, and much more. See the main MS SQL Server Features Page for more information.
SQL Editor Features
- Transact-SQL syntax highlighting
- Transact-SQL Auto Procedure and Function Lookup
- SQL syntax highlighting
- SQL function lookup
- Auto table lookup and completion
- Auto column lookup and completion
- Extensive find, replace, and find / replace in files functionality
- Bracket, parenthesis, and brace auto matching
- Support for parameterized queries
- SQL Formatter
- Execute, Execute Fetch All, and Execute Batch functions
- Multi-Tabular Display of Query Results
- Sortable Query Results
- Filterable Query Results
- Searchable Query Results
- SQL History for All Queries, and Query Logging Per Connection
- Query navigator for displaying a clickable display of queries in the editor
- Key Ahead functionality for one-click population of user-defined text
- Built-in and Custom User Templates
- Connection Keep-Alive
- Plugin API (Allows users to add custom functionality to RazorSQL)
The MS SQL Server SQL and Transact-SQL editor will automatically configure TSQL specific syntax highlighting on connection to a MS SQL Server database. This gives users the ability to do function lookup on Transact-SQL functions, etc. Upon connection to an SQL Server database, the editor also activates such features as the ability to view print output.
