我拥有2005年Sql服务器数据库,其中某些数据将每天从外部系统(Oracle)更新。 具体来说,一些表格每天将装满负荷,我需要安排一份工作,直到最后一张桌复读后才开始。 我如何能够这样做? 我是否应当使用一个表格储存数据负荷的具体信息,并定期从中读取,作为板块工作的第一步? 感谢!
外部数据库的最后一点是更新目前的运行。 当你完成工作时,她会安排上下班=现在。 当你开始工作时(如果两个班子在X年期间试图与某个人不同,就会检查其身份;如果情况不同,则你的工作就会失败。
You need mechanism to know that external system finished updating your data.
Guess it is some table (SYNC_TBL for instance) in SQL Server that external system inserts to or updates some record to notify end of update by external system.
If You need to:
Note that You need to have another check on external system side: updating data probably should not start again until job finishes its execution. You can use column Processed BIT in SYNC_TBL to mark whether data is processed by your job or not.
I have installed ASP.NET application with database on our server. ASP.NET application created database using connection string below. The problem is that I do not see database in SQL Server Management ...
What datatype is the most efficient to store a number such as 11.111. The numbers will have up 2 digits before the point and up to three after. Currently the column is a bigint , I am guessing that ...
是否需要在提瓜表之后更新表格统计数据,还是自动更新?
Ok, so I ve got a bit of a SQL and Powershell problem. There are 2 SQL scripts, one to setup 4 different global stored procedures. Another to execute them and manipulate data before returning it to PS ...
I add a column of type tinyint and being set to not allow nulls in a table and generate the change scripts. The table has data in it at this time. The script has code that creates a temp table and ...
I am currently working on a particularly complex use-case. Simplifying below :) First, a client record has a many-to-one relationship with a collection of services, that is, a single client may have ...
I have a particularly troublesome xml column to query data from. The schema is fixed by the Quebec Ministry of Revenue so "it is what it is" The important part of the query looks like this: with ...
I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...
