Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Im new to SQL Server and can hardly compose the SQL-statements by hand. Does the STUDIO have a visual query builder like MS ACCESS?

April 26, 2017compose hand hardly query SQL Server sql-statements Studio Visual

0

Posted

Im new to SQL Server and can hardly compose the SQL-statements by hand. Does the STUDIO have a visual query builder like MS ACCESS?

1 Answer

0

Posted

Yes, the STUDIO has a powerful visual query builder that allows a newbie build a complex queries while drasticly save time for advanced users. All you need to do is to specify the tables that will be used in the query, their relations and the data you want to get. The visual query builder will create a text of the query for you. You will only need to run it. You can see the result of your query and make corrections if nesessary. The changes can be made from the visual builder or from the text editor. As changes made in visual query builder, the text editor will display them too and vice versa.