Loading

Insert using OpenRowSet

Shouketh EK

17y7.8k

hai friends
Good Day.....
i have 2 sql server in differend location. that connected with VPN. i wand to insert value my connected server. so i'm usinf openRowSet like this....
INSERT OpenRowSet('SQLOLEDB','Server=User-2,1433;UID=sa;PWD=;Trusted Connection=yes;') INTO triger..A (number) VALUES ('ss')
i'm getting error incorrect syntax near ')'.
any one know ... update me....!!!
thank you
Shouketh

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Roei Bar17y ago
Accepted answer
you are correct this is not the sintax you need to write it like this insert into OPENROWSET('provider', 'SELECT * FROM Table1') select * from SQLServerTable
0