Home Forums SQL Server 2005 SQL Server 2005 General Discussion Is it "better" to specify the definition of a temporary table, or just define it on the fly? RE: Is it "better" to specify the definition of a temporary table, or just define it on the fly?

  • Hi,

    For known column I use create table and then insert

    For creating a table from another table schema I use insert into.

    Have used both, but honestly i prefer 'insert into' because then you dont have to know all columns before insertion.

    Here, I guess it doesnt matter which one you use.

    🙂