|
Posted by eeb4u@hotmail.com on 01/11/08 03:20
I am connecting to MS SQL 2000 from Red Hat EL4 using freetds and
currently running queries to get counts on tables etc. When running
SELECT queries I notice that the data returns and I have to parse out
the field names etc. Is there any easier way to extract the data in a
comma separated form?
I was thinking of reading the contents into a structured file or
buffer and then getting the field names that way. However I thought I
might be over engineering a simple query script, but I haven't come up
with a simpler way yet.
Basically, I am trying to writing a script on linux that queries the
database I and with the results of that query it will create an insert
statement for another database.
Any suggestions are welcome.
Mike
Navigation:
[Reply to this message]
|