Thanks Guys .. especially the article regarding triangular joins was very useful.

No, i havent tried for such case.... my only concern is that i want to know how tht query works ?

Hi all,

I have a script as below :

update top (2) test_table

set age = age + 50

When i run the above script in sql 2005 it...