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 |
|
al91206
Starting Member
1 Post |
 Posted - 2011-05-12 : 12:21:18
|
| Hey all,Worked on a few different types of databases, but new to SQL Server and I have a couple of questions:1. I see lots of column.name AS Alias <-- why use "AS" when it doesn't appear to be necessary?2. The joins - I normally use: table1.column = table2.column - but in sql server I notice the format is totally different - seems more complicated. Does the manner of join (using = vs. using join on syntax) affect the query performance?Any info is appreciated.Thanks,Al |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-05-12 : 12:51:17
|
| 1. Usually programmers preference2. What do you mean?table2 Left join table1 on table2.pk = table1.pkWhat's wrong with that?JimEveryday I learn something that somebody else already knew |
 |
|
|
|
|
|
Formatting questions - select statements