Post reply

Need help copying one table to another. Should be easy.

  • October 10, 2005 at 12:44 am

    #596208

    Hi u can use this!!!

     

    SELECT * INTO <Destination_Table>

    FROM

    (

    SELECT * FROM <Source_Table>

    ) S

    Regards,

    Papillon

  • October 11, 2005 at 7:17 am

    #596522

    He already tried that.

  • October 11, 2005 at 11:33 am

    #596596

    not sure if sql server has a default for rowcount

    What does

    SET ROWCOUNT 0 /*all rows*/

    select *

    from  ....

    gives

    you can query your connection settings with

    DBCC USEROPTIONS

Viewing 3 posts - 16 through 17 (of 17 total)

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