question

Rashi avatar image
Rashi asked

How to compare temp table field with linked server table field openquery

My Query is like.. insert into openquery("linkedserver","select * from table") select distinct * from #temp where upd=1 and upd2=2 now please tell me how I can do the comprasion with table feild with temp for removing the error of primary key constraint
openquerytemp
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.