Does SQL Server cache data results for DAO?
While I would usually leave an answer this short as a comment, this seems to be worthy of breaking with good practice.

No. Nonsense. Absolutely not.

The answer that @gbn gave to the question you reference is valid, regardless of the method of query. Stored procedure or adhoc, the same applies... Query results are not cached.


  However, the source table and index data and metadata will be cached
  after the 1st use (subject to continued use, load and memory pressure
  though)
  
  That is, the results of a query will be evaluated every execution but
  the tables(s) (and any indexes etc) used by the query will most likely
  be in memory already.


The "some sort of caching for DAO" is client/API behaviour, irrelevant and unbeknownst to SQL Server.