TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Shouketh EK
NA
36
30k
Insert using OpenRowSet
Aug 7 2009 7:11 AM
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
Reply
Answers (
1
)
Diffence between two date in sql server
Connecting SQL Server 2005 database from Windows Mobile 6.0