Post reply

Do temp tables exist in sqlce 2005?

  • July 23, 2008 at 2:38 pm

    #191516

    Just curious if you can create temp tables in sqlce. I tried but no luck. Some posts I have read elsewhere made me think it was possible - but I am wondering if those were true.

    Just trying to do something like this:

    CREATE TABLE #t1 (c1 int, c2 int, c3 char(5000));

    Basically I want to get around nested select statements by using temp tables - maybe neither exist...

  • July 23, 2008 at 10:02 pm

    #847507

    "Basically I want to get around nested select statements by using temp tables"

    Make sure you really want to do this. MAny times a subquery approach can dominate any temp table code. Not always true, and maybe CE is different somehow.

    I would think CE would have to be able to create Temp tables at least for its internal filters and sorts?? Interesting question thanks.

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

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