Results 1 to 3 of 3
  1. #1
    Join Date
    May 2008
    Posts
    5

    Question Unanswered: Select into FOR large row number

    I have row number with more than 400 rows. I use select into statement. It only allow 175 rows to get copied into Tem_Table. How to get all rows copied when create new table?

    select id, code into Tem_table from Name where code = '11'

    Your help is highly appreciated.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    cross post?

    SQL Server Forums - Select into FOR Large row number

    Seriously

    What are you asking?

    Post DDL, expected results and sample data if you want an answer
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    May 2008
    Posts
    5
    My question is:

    select id, code into from Name where code = '11'

    It showed total: 480 rows.

    However, I use:

    select id, code into Tem_table from Name where code = '11'

    Showed only 175 rows effected.

    then I test:

    select id, code from Tem_table where code = '11'

    It only showed: 175 rows. HOW TO GET 480 ROWS COPY INTO Tem_table?

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •