hello all,

I'm would like to insert a list of variable into a SQL table.
So, far i have not had much luck. Follwing is a sample of what I'm doing:

#Insert into Table
$X=10.123456
$Y=20.234567

$Server = "LOCALHOST\SQLEXPRESS"
$DataBase = "MYDBNAME"
$conn = new-object System.Data.SqlClient.SqlConnection
"server=$server;database=$dataBase;Integrated Security=sspi"
$cmd = New-Object "System.Data.SqlClient.SqlCommand"
$conn.Open()
$cmd.Connection = $conn
$cmd.CommandText = "INSERT INTO [MYDBNAME].[dbo].[TABLENAME]"
$cmd.CommandText += "(X)"
$cmd.CommandText += "(Y)"
$cmd.CommandText += " VALUES "
$cmd.CommandText += "($($X), decimal(14,10)"
$cmd.CommandText += ",$($Y), decimal)(14,10))"
$rdr = $cmd.executereader()
$rdr.close()
$conn.close()
$cmd=$null



Any Ideas?
Thanks in advance,
Bruce Williams

$Server = "LOCALHOST\SQLEXPRESS"
$DataBase = "MYDBNAME"
$conn = new-object System.Data.SqlClient.SqlConnection
"server=$server;database=$dataBase;Integrated Security=sspi"
$cmd = New-Object "System.Data.SqlClient.SqlCommand"
$conn.Open()
$cmd.Connection = $conn
$cmd.CommandText = "INSERT INTO [MYDBNAME].[dbo].[TABLENAME]"
$cmd.CommandText += "(X)"
$cmd.CommandText += "(Y))"
$cmd.CommandText += " VALUES "
$cmd.CommandText += "($($X), decimal(14,10)"
$cmd.CommandText += ",$($Y), decimal)(14,10))"
$rdr = $cmd.executereader()
$rdr.close()
$conn.close()
$cmd=$null

Any Ideas?
Thanks in advance,
Bruce Williams

"B Williams" <a09252003@xxxxxx> wrote in message
news:B1F6254D-43B1-424F-86D4-5EF15D42DC3A@xxxxxx

> hello all,
>
> I'm would like to insert a list of variable into a SQL table.
> So, far i have not had much luck. Follwing is a sample of what I'm doing:
>
> #Insert into Table
> $X=10.123456
> $Y=20.234567
>
> $Server = "LOCALHOST\SQLEXPRESS"
> $DataBase = "MYDBNAME"
> $conn = new-object System.Data.SqlClient.SqlConnection
> "server=$server;database=$dataBase;Integrated Security=sspi"
> $cmd = New-Object "System.Data.SqlClient.SqlCommand"
> $conn.Open()
> $cmd.Connection = $conn
> $cmd.CommandText = "INSERT INTO [MYDBNAME].[dbo].[TABLENAME]"
> $cmd.CommandText += "(X)"
> $cmd.CommandText += "(Y)"
> $cmd.CommandText += " VALUES "
> $cmd.CommandText += "($($X), decimal(14,10)"
> $cmd.CommandText += ",$($Y), decimal)(14,10))"
> $rdr = $cmd.executereader()
> $rdr.close()
> $conn.close()
> $cmd=$null
>
> Any Ideas?
> Thanks in advance,
> Bruce Williams

It appears that you are forming a sql statement that would look like:

INSERT INTO [MYDBNAME].[dbo].[TABLENAME](X)(Y) VALUES (10.123456,
decimal(14,10)), 20.234567

which is not legal sql

valid sql would be

INSERT INTO [MYDBNAME].[dbo].[TABLENAME] (X,Y) VALUES (10.123456, 20.234567)





"B Williams" wrote:

> $Server = "LOCALHOST\SQLEXPRESS"
> $DataBase = "MYDBNAME"
> $conn = new-object System.Data.SqlClient.SqlConnection
> "server=$server;database=$dataBase;Integrated Security=sspi"
> $cmd = New-Object "System.Data.SqlClient.SqlCommand"
> $conn.Open()
> $cmd.Connection = $conn
> $cmd.CommandText = "INSERT INTO [MYDBNAME].[dbo].[TABLENAME]"
> $cmd.CommandText += "(X)"
> $cmd.CommandText += "(Y))"
> $cmd.CommandText += " VALUES "
> $cmd.CommandText += "($($X), decimal(14,10)"
> $cmd.CommandText += ",$($Y), decimal)(14,10))"
> $rdr = $cmd.executereader()
> $rdr.close()
> $conn.close()
> $cmd=$null
>
> Any Ideas?
> Thanks in advance,
> Bruce Williams
>
> "B Williams" <a09252003@xxxxxx> wrote in message
> news:B1F6254D-43B1-424F-86D4-5EF15D42DC3A@xxxxxx

> > hello all,
> >
> > I'm would like to insert a list of variable into a SQL table.
> > So, far i have not had much luck. Follwing is a sample of what I'm doing:
> >
> > #Insert into Table
> > $X=10.123456
> > $Y=20.234567
> >
> > $Server = "LOCALHOST\SQLEXPRESS"
> > $DataBase = "MYDBNAME"
> > $conn = new-object System.Data.SqlClient.SqlConnection
> > "server=$server;database=$dataBase;Integrated Security=sspi"
> > $cmd = New-Object "System.Data.SqlClient.SqlCommand"
> > $conn.Open()
> > $cmd.Connection = $conn
> > $cmd.CommandText = "INSERT INTO [MYDBNAME].[dbo].[TABLENAME]"
> > $cmd.CommandText += "(X)"
> > $cmd.CommandText += "(Y)"
> > $cmd.CommandText += " VALUES "
> > $cmd.CommandText += "($($X), decimal(14,10)"
> > $cmd.CommandText += ",$($Y), decimal)(14,10))"
> > $rdr = $cmd.executereader()
> > $rdr.close()
> > $conn.close()
> > $cmd=$null
> >
> > Any Ideas?
> > Thanks in advance,
> > Bruce Williams

>

Thanks,

Sleep can sharpen ones focus!


"Leo Tohill" <LeoTohill@xxxxxx> wrote in message
news:2B669001-EC86-421B-9481-CC2DBAA3E4E7@xxxxxx

> It appears that you are forming a sql statement that would look like:
>
> INSERT INTO [MYDBNAME].[dbo].[TABLENAME](X)(Y) VALUES (10.123456,
> decimal(14,10)), 20.234567
>
> which is not legal sql
>
> valid sql would be
>
> INSERT INTO [MYDBNAME].[dbo].[TABLENAME] (X,Y) VALUES (10.123456,
> 20.234567)
>
>
>
>
>
> "B Williams" wrote:
>

>> $Server = "LOCALHOST\SQLEXPRESS"
>> $DataBase = "MYDBNAME"
>> $conn = new-object System.Data.SqlClient.SqlConnection
>> "server=$server;database=$dataBase;Integrated Security=sspi"
>> $cmd = New-Object "System.Data.SqlClient.SqlCommand"
>> $conn.Open()
>> $cmd.Connection = $conn
>> $cmd.CommandText = "INSERT INTO [MYDBNAME].[dbo].[TABLENAME]"
>> $cmd.CommandText += "(X)"
>> $cmd.CommandText += "(Y))"
>> $cmd.CommandText += " VALUES "
>> $cmd.CommandText += "($($X), decimal(14,10)"
>> $cmd.CommandText += ",$($Y), decimal)(14,10))"
>> $rdr = $cmd.executereader()
>> $rdr.close()
>> $conn.close()
>> $cmd=$null
>>
>> Any Ideas?
>> Thanks in advance,
>> Bruce Williams
>>
>> "B Williams" <a09252003@xxxxxx> wrote in message
>> news:B1F6254D-43B1-424F-86D4-5EF15D42DC3A@xxxxxx

>> > hello all,
>> >
>> > I'm would like to insert a list of variable into a SQL table.
>> > So, far i have not had much luck. Follwing is a sample of what I'm
>> > doing:
>> >
>> > #Insert into Table
>> > $X=10.123456
>> > $Y=20.234567
>> >
>> > $Server = "LOCALHOST\SQLEXPRESS"
>> > $DataBase = "MYDBNAME"
>> > $conn = new-object System.Data.SqlClient.SqlConnection
>> > "server=$server;database=$dataBase;Integrated Security=sspi"
>> > $cmd = New-Object "System.Data.SqlClient.SqlCommand"
>> > $conn.Open()
>> > $cmd.Connection = $conn
>> > $cmd.CommandText = "INSERT INTO [MYDBNAME].[dbo].[TABLENAME]"
>> > $cmd.CommandText += "(X)"
>> > $cmd.CommandText += "(Y)"
>> > $cmd.CommandText += " VALUES "
>> > $cmd.CommandText += "($($X), decimal(14,10)"
>> > $cmd.CommandText += ",$($Y), decimal)(14,10))"
>> > $rdr = $cmd.executereader()
>> > $rdr.close()
>> > $conn.close()
>> > $cmd=$null
>> >
>> > Any Ideas?
>> > Thanks in advance,
>> > Bruce Williams

>>