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 |
|
samsun125
Yak Posting Veteran
63 Posts |
 Posted - 2008-12-08 : 03:39:34
|
| Hi all,i want to know the advantages and disadvantages of subqueries?if anybody knows please help meThanks & RegardsRamaDevi |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2008-12-08 : 04:22:32
|
| Compared to what? If you need them to answer your question then there are no downsides. If you know something about your data that you have not told the DB there can be faster ways of getting the same result but if your tables are modelled right it all washes out more or less the same. |
 |
|
|
|
|
|
what is the advantages and disad's of subquery's?