tsql track all changes related to one table in the database -

-

i have transactional db, table t1 pk , want track changes occurred in tables related t1. thought of using cdc, able browse existing cdc tables see ones have changes related t1 proved bit of challenge. easy changes tables connected t1 directly, no matter level (e.g. tn has fk tn-1, has fk tn-2 etc has fk t2 has fk t1). don't know how create script changes tables not connected directly, e.g. t6 has fk t5 has fk t4, t3 has fk t4 , t2, , t2 has fk t1 (1st or through multiple levels), t6 connects t1 in end, not through 1 way type of relationship.

does have idea on how this?

a specific example: have table contracts has column contractid , other columns , want create history table holds changes related contractid, have columns contractid, oldvalue, newvalue. these changes can come a) tables have fk contracts.contractid, example tblperiod(periodid, contractid, etc), b) tables reference contracts.contractid through multiple relationships, e.g. tblsubperiod (subperiodid, periodid, etc) references tblperiod references contracts.contractid or c) tables can't connected contracts through fk keys, e.g. tblcomissionshare has fk tblcommission, tblsubperiod has fk tblcommission , know above, tblsubperiod has fk tblperiod has fk contracts. change in table tblcommissionshare should appear in history table. querying cdc tables need dynamic query generates joins between table contracts , other tables relate described above can populate history table.


Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more