Posting Yak Master
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
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,