Great stuff. I have no problems at all with get-sqldata, but I cant get set-sqldata to work...
Ok, so this works
Get-SqlData 'VISTA-LAPPY\SQLEXPRESS' Worldship 'SELECT top 3 * FROM
dbo.UPSData'
But this does not...
Get-SqlData 'VISTA-LAPPY\SQLEXPRESS' Worldship 'INSERT INTO dbo.UPSpod
(Sheet, User) VALUES (4, Jim)'
Nether does:
Set-SqlData 'VISTA-LAPPY\SQLEXPRESS' Worldship "INSERT INTO dbo.UPSpod
(Sheet, User) VALUES (4, 'Jim')"
The insert statement works in SQL, so I am not sure what i am
missing.... Hope you can help.