DbForge Query Builder for SQL Server

DbForge Query Builder for SQL Server Is a program for easily and quickly building SQL queries against SQL Server databases. The program allows you to create SQL queries visually without writing code, as well as using the SQL code editor to write the text of the request manually. When writing SQL queries manually, the code completion tools make it much easier to compose queries. A user-friendly graphical interface allows you to flexibly configure the sampling parameters from Microsoft SQL Server databases.
Main Functionality DbForge Query Builder for SQL Server
Easy and convenient navigation to databases The database explorer makes it easy to navigate through databases through a tree-like list that shows the structure of the database and allows you to view all objects. Visual creation Queries with joins and subqueries When working with dbForge Query Builder for SQL Server, you can use the Visual Query Designer. Using drag-and-drop operations, you can create complex SQL queries with a few mouse clicks. Expression Editor The built-in expression editor allows you to add complex sample conditions and grouping criteria to the SQL query using the mouse. Creature Queries in a text editor You can use the built-in SQL query editor to write the text of queries manually. The editor has code completion and syntax highlighting, which significantly reduces the time it takes to write a query. View the query execution plan DbForge Query Builder for SQL Server allows you to view detailed SQL query execution plans, which allows you to analyze the performance-related aspects of queries. A visual query profiler will let you know how much time it takes to read from disk, lock tables, unload into memory. Very useful information can be the amount of memory used or the processor load at each stage of the query. Also, you can view the differences in profiling results after making changes. Working with query results DbForge Query Builder for SQL Server has all the necessary tools for working with data that was returned by the server in response to the request. You can view the contents of fields, sort, group and filter the result set of records. Export query results The program allows you to export data to 10 popular formats: HTML, Text, MS Excel, MS Access, RTF, PDF, XML, CSV, DBF, ODBC.
System requirements:

• Operating system Microsoft Windows XP / 7/8 / 8.1 or Windows Server 2008/2012
• .NET Framework 3.5SP1, 4.0, or 4.5
• A processor with a clock speed of 2 GHz or higher
• 150 MB of free hard disk space to install the program
• 1024 MB of RAM