|
zero1de
Yak Posting Veteran
Germany
66 Posts |
 Posted - 01/10/2013 : 05:59:07
|
I have tried all the possibilities to write data on a MS SQL Server via trigger to a Oracle table.The only possible way is to use OpenQuery with dynamic SQL. But I just have no idea of dynamic SQL!
My question is who can help me to get a working dynamic SQL
CREATE TRIGGER [dbo].[TRG_INSUPDDEL_Tab] ON [dbo].[Tab]
FOR UPDATE, Insert, Delete
AS
insert into openquery([Server],'select DS_TYPE,DW_DOC_ID,DW_ARCHIVE, DW_MOD_DATE from User.T_SI_CHANGED_BK')
Select 'I' as DS_TYPE,
as DWDOCID,
as DW_DOC_ID,
as PRODUNIT,
as DW_ARCHIVE,
as DWMODDATETIME
from inserted |
|
Openquery with dynamic sql
