Select into FOR large row

[sow12]

Hello:

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.

 

[markros]

It should work.

Try

select count(*) from [Name] where code = '11'

select id, code into #temp_Table from [Name] where code = '11'

print @@rowcount

 

[markros]

See also

http://social.msdn.microsoft.com/Fo...l/thread/25e6f5c0-fd8a-4dd6-a874-f74ff22b7903

 

[tcsbiz]

I'm guessing that there are only 175 rows where code = '11'.