Dynamic Query + linked Server + update

Last Post 21 Jun 2004 06:10 AM by naminha. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
naminha
New Member
New Member

--
21 Jun 2004 06:10 AM
Hi,

I am trying to update an Oracle table using a linked server from MS SQL Server.

Please help me re-write this query.

select @str = "Update openquery(link_vptpilot,'
select * from enterprise_resources where e_res_uid = ' + convert(char,@res_uid)+')'+
'set e_res_name = ' + @res_name + ',' + e_res_uid = ' + convert(char,@res_uid) "

I want a general syntax for updating Enterprise_resource table in Oracle . I will be updating (i.e., set = ) text, number and date fields.

Any help is greatly appreciated.

Thanks.

Navin
You are not authorized to post a reply.

Acceptable Use Policy