dbForge Query Builder for SQL Server allows users to build quickly and easily complex SQL queries via an intuitive visual interface without manual code writing. Our visual SQL query tool is designed to simplify development of SQL queries for SQL Server. Visual features and graphical SQL query designer for interactive query building will be most appreciated by users who often create databases queries.
Data Editor:
Asynchronous data fetch with ability to cancel the operation
Batch table update mode when changes are accumulated and applied explicitly
Copying data with column headers for quick paste to spreadsheet
Custom data filters of any complexity
Data Viewer and Editor window for browsing and editing large objects
Date time editor with visual interface
Foreign key lookup editor for easy editing of fields referencing other tables
Full-text search (Ctrl+F) through data grid
Graphical card view
Grouping by arbitrary columns
Incremental search (Ctrl+I) through data grid
Multi-table query result set editing
Paginated data browsing for large result sets
Server-side sorting and filtering to help dealing with large data sets
Visible columns picking dialog box
Editing microseconds in columns with the TIME, DATETIME and TIMESTAMP data types
Database Explorer
Multiple database connections allowed
Asynchronous connect to server with ability to cancel the operation
Detailed object properties and data browsing in Object Viewer window
Quick script generation for an object: SELECT, INSERT, EXECUTE, etc
'Send To' command for quick sending of tables to Query Builder
Multi-selection for batch operations on objects
Database navigation history
Exporting Data
Data export to: JSON, CSV, XML, Text, XLS, PDF, DBF, HTML, RTF, MDB (Access), ODBC, and SQL
Export data from multiple tables at once
Component Property | |
Component Type | SQL |
Component Environments | SQL Server |
Version | v3.11 |