Post reply

How do we access SQL cached data ??

  • November 25, 2009 at 4:52 am

    #136420

    Hi all,

    Can we access SQL cached data ? If yes then how do we achieve it?

    Means suppose i run some query like

    select * from XXXXX or output of SP

    then can access the output of this query/SP from SQL cache???:-)

  • November 25, 2009 at 11:05 am

    #1084227

    Usually you use the recorset as it is returned to the calling application. Such as in VB.NET you create your data adapter and your data table. Then when you execute the query you you fill the data table with the resultset.

    Sometimes I use # temp tables to store record sets, but that is just until you close the query window or the procedure ends.

    -- Example:

    SELECT 'Adam' as Name, '111 fake address' as Address INTO #tempaddress

    SELECT * from #tempAddress

    DROP TABLE #tempAddress

    Hope that helps,

  • November 25, 2009 at 11:54 am

    #1084255

    In SQL you don't access the cached data directly, SQL will use cached data to satisfy queries if it can but you can't say I want to use THIS cached data.. But I guess that depends on what you consider cached data..

    CEWII

  • November 26, 2009 at 1:06 am

    #1084469

    thanks guys...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply