Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL server features

Author  Topic 

Johnseito
Starting Member

28 Posts

Posted - 2014-11-20 : 20:48:44
Does SQL server have this feature where you type the code
in editor and you create a join between two tables, if
there are fields in the two tables that matched or
doesn't while you are creating the join - you see could see where they match/join in editor ?


Thx

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-11-21 : 09:10:37
SSMS has this function. Under the Query menu, select Design...
Go to Top of Page

Johnseito
Starting Member

28 Posts

Posted - 2014-11-21 : 22:53:56
I don't see Query Menu - where is that ?
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-11-22 : 09:39:33
in ssms, connect to a database then click the n"new query" button. on the top menu row, between View and Project, you should see the Query menu
Go to Top of Page

Johnseito
Starting Member

28 Posts

Posted - 2014-11-22 : 14:49:04
Ok - I clicked on the query menu, the only design I see is the "Design in Query Editor" is that the design you are referring to ?

If so, this is not what I meant when I say that when you type your query or write your query statement and implement a join, SQL server automatically show you all the fields that are common with the table you are joining.

I see this in the TOAD platform, I haven't seen it in SQL server.
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-11-22 : 15:50:00
Yes, well you can accomplish the same thing with the design mode. Or, you can install APEX SQL Complete or something similar. The functionality you seek is not in SSMS out of the box.
Go to Top of Page

Johnseito
Starting Member

28 Posts

Posted - 2014-11-22 : 21:54:02
Ok, thanks for the info.

I recently use TOAD and it has that function and I just was wondering if I could use in the same way in SQL server.

Is slightly different though.
If it has the TOAD feature it makes writing the Query easier.
Just saying !
Go to Top of Page
   

- Advertisement -