I've seen the following query from a vendor product, and wondering what NO_BROWSETABLE actually achieves by including it for this select.
SET NO_BROWSETABLE ON
SELECT * FROM TABLE1 A, TABLE2 B WHERE (A.COLUMN1=B.COLUMN1) AND A.COLUMN1) ='57 ORDER BY B.ORDER
SET NO_BROWSETABLE OFF
I've seen explanations online, but I still don't get why you'd use it for a simple select. Can anyone provide a simple explanation? I can't seem to work out if doing this is a good thing or bad thing.