Re: Temp Table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Gabriel (antongc_at_yahoo.com)
Date: 09/09/04

  • Next message: Cristian Babu: "Re: Temp Table" 
    Date: Thu, 9 Sep 2004 11:35:21 +0300

    The field type of the temp table when using select into statement is the
    same with the type of fields from your select
    Gabriel Anton

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

    "Justin Drennan" <justin@none.com> wrote in message
    news:Z8OdndnUeLvLjt3cRVn-qw@is.co.za...
    > How do I specify the field type when creating a temp table?
    >
    > (I am doing a Select into statement)
    >
    > Thanks
    >
    >

  • Next message: Cristian Babu: "Re: Temp Table"

    Relevant Pages

    • Re: Temp Table
      ... Cristian Babu ... > How do I specify the field type when creating a temp table? ...
      (microsoft.public.sqlserver.programming)
    • Re: Temp Table
      ... Select cast) into newtable from tablename ... - Ketan Patel ... >> How do I specify the field type when creating a temp table? ...
      (microsoft.public.sqlserver.programming)
    • RE: decimal not showing correctly in append query
      ... The field type Long Integer means there are no decimal places even if you ... specify some. ... "naiveprogrammer" wrote: ... > I have an append query that is not showing the cents in a number field. ...
      (microsoft.public.access.queries)
    • Re: 2006-07-26 00:00:00
      ... I haven't worked with OLE automation in Office in some time, ... you specify the field type in Word? ... It soulnd like it's looking for a ...
      (comp.databases.ms-sqlserver)
    • Re: Can I create a date field in a make table query?
      ... "my current method" is my going into Table Design and MANUALLY changing the field type from Text to ... So the question is, can I specify that this field be of type "Date" in my query, and if so, how? ...
      (microsoft.public.access.queries)