Post reply

sql server compact edition

  • February 11, 2009 at 11:33 pm

    #200257

    hey ...can anybody hlp me to tell tht how can i create temporary tables in sql server compact edition .....nd i know tht fact ....temp tables arent supported bt compact edition

    thanks in advance !

  • February 11, 2009 at 11:35 pm

    #942627

    hey ...can anybody hlp me to tell tht how can i create temporary tables in sql server compact edition .....nd i know tht fact ....temp tables arent supported by compact edition

    thanks in advance !

  • February 12, 2009 at 6:06 am

    #942758

    I'm sorry, but you can't create temporary tables in CE. Since you know this, why are you asking the question?

    BTW, you can nest queries in 3.5 & above, does that help?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 12, 2009 at 7:22 am

    #942834

    I'll take a shot at this one.

    ---------------------------

    First solution:

    Since you can't create temporary tables, you create a permanent table with a column to identify each session uniquely.

    You populate that table and then select back only those rows that belong to your session.

    At the end of your session, you delete all those rows.

    Periodically you truncate it when nobody is using it, to clean up data from any sessions that terminated unexpectedly.

    ------------------------------

    Second solution:

    Do it all in dynamic SQL. Create unique table names starting with TEMP_. Drop the table when you're done. Periodically drop all tables starting with TEMP_

    ------------------------------

    Neither of these are pretty.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • February 12, 2009 at 10:02 pm

    #943349

    thanks a lot !!! i ll try these two options .....

Viewing 5 posts - 1 through 5 (of 5 total)

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