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 |
|
VipinMitta
Starting Member
12 Posts |
 Posted - 2010-04-26 : 03:44:19
|
| Dear All,anybody know.......how many join we can apply with 3 tables in a single query?(in sql 2000 and 2005 ) |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-04-26 : 03:46:12
|
What exactly do you mean with that ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-04-26 : 03:51:51
|
or are you looking for this info ?both SQL 2000 & 2005 can have max 256 tables per selecthttp://msdn.microsoft.com/en-us/library/aa933149%28SQL.80%29.aspxhttp://msdn.microsoft.com/en-us/library/ms143432%28SQL.90%29.aspx
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-26 : 03:52:32
|
| depends on situation. whats your scenario?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
maximum number of join with 3 tables??