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 |
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
 Posted - 2008-01-17 : 09:20:33
|
| I'm trying to find more info about derived and derivedtbl keywords, but i'm having trouble finding info on technet.microsoft.com. Basically, I'd like more information on the keywords in queries and inline views. I see subqueries ending with "subquery" and "as [alias]. If anyone can point me in the right direction, I'd appreciate it. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-01-17 : 09:46:27
|
| I don't understand what you are talking about. Derived table is not a keyword but a concept, same thing for subquery.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
Posted - 2008-01-17 : 09:59:27
|
| Yes, I see that now. I was browsing the interweb and found this site:http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic10174.aspxThere's a bunch of complex queries on the site using the word subquery and I saw derived some place and figured they were keywords. I thought all queries with inline views have to end with the word derivedtbl, because that's what sql automatically inserts. |
|
|
|
|
|
|
derived vs. derviedtbl