Why wouldn't you do the insert directly into the TEST.XYZ.POLICY?
Dave Cahall
Vice President, Professional Services
Digitaris Technologies, Inc.
Office: 972.690.4131 ext 116
Mobil: 214.914.9947
-----Original Message-----
From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 11:28 AM
To: '[EMAIL PROTECTED]'
Subject: OpenQuery Inserting?
execute("SELECT * FROM OPENQUERY(TESTSERVER,"" SELECT * FROM TEST.XYZ.POLICY
"") ")
How can I do an insert? The above select works.
Tried the below:
execute("SELECT * FROM OPENQUERY(TESTSERVER,"" Insert into TEST.XYZ.POLICY
(testcolumn) values (1) "")
")
Thanks,
Nathan Stanford
Senior Programmer/Analyst
[EMAIL PROTECTED]
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
