Answer the question
In order to leave comments, you need to log in
How can you make such a scenario: fetching data into the archive, if successful, mark that the data has been sent?
There is a database data source, and there is a table in it:
CREATE TABLE dbo.Data (
ItemId INT IDENTITY,
Value NVARCHAR(50) NOT NULL,
CreationDtStamp DATETIME2 NOT NULL CONSTRAINT DefaultDtStamp DEFAULT (GETDATE()),
Replicated BIT NULL CONSTRAINT DefaultReplicated DEFAULT (0),
CONSTRAINT PK_Data PRIMARY KEY CLUSTERED (Itemid)
) ON [PRIMARY]
GO
INSERT INTO Data (Value)
VALUES
('sssss'),
('3333'),
('44444'),
('55555'),
('667u77'),
('hhhhhhh'),
('8888888'),
('ss99999sss');
CREATE TABLE dbo.Data (
Itemid INT,
Value NVARCHAR(50) NOT NULL,
CreationDtStamp DATETIME2 NOT NULL,
ReplicationDtStamp DATETIME2 NOT NULL CONSTRAINT DefaultReplicationDtStamp DEFAULT GETDATE(),
CONSTRAINT PK_Data PRIMARY KEY CLUSTERED (Itemid),
) ON [PRIMARY]
GO
SELECT TOP (3)
ItemId,
Value,
CreationDtStamp
FROM Data WHERE Replicated = 0;
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question