Query Drawing 1

[Toshilap]

You know how in Access you can write query - see join tables in design view and flip to SQl statement?

I need to have the same thing done with SQL Server.
I have a query that I need to be able to show drawing for tables how they joined together. Is there way to do this?

Also is there way for me to run this drawing/query to make sure I joined tables correctly on my diagram?

It was so convenient in Access...but have to move on.
Thanks


I finally got it all together and forgot where I put it.

 

[gmmastros]

If you use Enterprise Manager to create a view, you will get a graphical layout for your query. It's different than Access, but also similar in many respects.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Toshilap]

The purpose of it is to let user wright their own query (I know...don't rell me, not my idea) and they have to see how to join tables. I have to make sure I am showing it correctly. Thanks again

I finally got it all together and forgot where I put it.

 

[SQLDenis]

open up EM, open a table you want to use, click on show diagram pane, right click in the top part select add table
add all you tables
click on show SQL pane to look at your SQL
hit ! to run it


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gmmastros]

If your users are already familiar with Access, then you can create an Access database that is linked to a SQL Server database. All the query building stuff is the same for them.

In a blank Access database, click File -> Get External Data -> Link

In the 'files of type', choose ODBC Databases(), configure ODBC to point to the proper server/database. There's more to it, but hopefully it will be obvious to you after you get started doing this.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Toshilap]

Denis,
open a table you want to use
I assume SQL view, right

click on show diagram pane
I don't think I see it...

Sorry, it would pe perfect solution.

I finally got it all together and forgot where I put it.

 

[Toshilap]

Denis,
I got it, thanks, will try to work it now.

I finally got it all together and forgot where I put it.