A SQL problem - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

A SQL problem

A SQL problem# Database - 数据库

p*s2005-08-11 07:08

1 楼

i get a table in sql, it's huge, and the next step for me is to put this table
into SPSS, so how can i save it. I know if i save it as 'xls', it cannot
handle that many rows. so how can i do it?

l*g2005-08-11 07:08

2 楼

Microsoft SQL server? Or something else?
I am not sure, but in Sybase, if the table is huge, you can use "cursor" to "
fetch" records...
if u use linux, there is not huge table at all, :) select them out and use awk
or perl to generate "CSV" file.

table

【在 p**********s 的大作中提到】

: i get a table in sql, it's huge, and the next step for me is to put this table
: into SPSS, so how can i save it. I know if i save it as 'xls', it cannot
: handle that many rows. so how can i do it?