SQL the next step !! (1 Viewer)

[ECEK]

I am totally aufait with the visual way in which to create queries in Access (Design View). I am also conversant with linking to a SQL Server (with help).

I am, however, totally inexperienced with any form of SQL coding.
Does SQL have a "visual" way of creating queries or is SQL as complex and daunting as it seems ?

What advice could you give for someone who needs to start using SQL Server?

 

[Uncle Gizmo]

I would suspect that most MS SQL developers would use MS Access, particularly the query designer and generally as a tool to experiment with their SQL statements.

I collect useful links here https://sites.google.com/site/msaccess457966vmfjg/learning-resources/ms-access-stuff

The Khan academy link may be of particular interest to you.

 

[Minty]

If you are using SQL Server Management Studio you can create query statements in a "visual" manner by creating a new view.

This will give you a pretty similar visual view to the Access query designer. It does have some differences though, you'll find them soon enough .

Views are very powerful server side for complex queries as they normally run much more efficiently than in Access.

 

[ECEK]

Thanks people. Much appreciated.

 

[Uncle Gizmo]

Oh! and this, looks interesting, havent used it myself....

http://ondras.zarovi.cz/sql/demo/

 

[ButtonMoon]

I would suspect that most MS SQL developers would use MS Access, particularly the query designer and generally as a tool to experiment with their SQL statements.

I can promise you most do not.

SQL Server Management Studio is by far the best tool for developing SQL Server queries. It has loads of useful features that you can't get in the Access query designer: a full object browser, intellisense, actual and estimated query plans, query batches - that's just for starters.

Note that the Access query designer GUI doesn't support complex SQL queries even for Access, let alone for SQL Server. You have to use the SQL view in Access to write many queries - and if you are going to write SQL you are better off writing it in SQL Server Management Studio or some other SQL development tool that supports "proper" SQL.