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.
| Author |
Topic |
|
Johnseito
Starting Member
28 Posts |
 Posted - 2014-11-20 : 20:48:44
|
| Does SQL server have this feature where you type the codein editor and you create a join between two tables, ifthere are fields in the two tables that matched ordoesn'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... |
 |
|
|
Johnseito
Starting Member
28 Posts |
Posted - 2014-11-21 : 22:53:56
|
| I don't see Query Menu - where is that ? |
|
|
|
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 |
|
|
|
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. |
|
|
|
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. |
|
|
|
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 ! |
|
|
|
|
|
|
|
|
SQL server features