|
Posted by Jack Vamvas on 01/11/08 16:29
Is this an inline sql statement or a stored procedure?
--
Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com
<eeb4u@hotmail.com> wrote in message
news:0d9a69ed-bf9f-4ad1-b215-99e2c7d6d559@k2g2000hse.googlegroups.com...
>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]
|