Hi guys,
I am writing a perl script that will take some command prompt parameters
and linking it with a SQL server database. I sort of have an idea on how
to do it. But need you guys to give me some directions as to which way
is the best.
First, I decided that I will need to generate the SQL statements inside
the perl script. (i.e. print SQL "insert... blah.."). But, I need to know
if this column I insert into has already existed or not? if not, create
it, otherwise just insert it. So, the simple question is can I do this?
The more complex question is can I embed SQL code blocks(procedures
and functions instead of a simple insert statement) inside perl script?
Thanks,
Eric
*********************************************************
*Eric T. Wang *
*Bioinformatic Support and DNA Sequencing Core SRA *
*University of California, Irvine College of Medicine *
*Department of Biological Chemistry *
*RK Moyzis Lab *
*[EMAIL PROTECTED] *
*949-824-1870 *
*********************************************************
