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 |
|
sinjin67
Yak Posting Veteran
53 Posts |
 Posted - 2008-12-30 : 23:25:25
|
| I have put together various SP's and a question came to mindreqarding joins. If in using an SP where a left join is beingused, Is the SP required to "break" the Join before commitingto another non related process ?Example would be you do an update where you have table Aand table B joined at the start of the SP, It looks at tableB and updates table A. Then moves on to deleting everything in table B. Until at such time a user has added data in tableB and called the SP via a onClick event or button.I only ask this because in Foxpro, "More so later version" you hadto at times break a join to isolate a single table for exclusiveuse. I have been reading what I can find but nothing seems to indicate one way or another...Thank you.... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sinjin67
Yak Posting Veteran
53 Posts |
Posted - 2008-12-31 : 01:30:25
|
| Thank you for your feedback.. I will try for a moreexciting question next time around.. |
 |
|
|
|
|
|
Joins