I have been fighting Visual Studio for a couple hours and managed to create the basic GridView configuration. Although in the much simpler Arduino environment, I am familiarized with C and I have recently written a couple Classes ( I should have started before ). Nevertheless helped by some web browsing I suppose I can handle the code behind the forms.
I decided to leave Excel for later and concentrate in creating and reading CVS files.
Then EPPlus or LinqToExcel might be more suitable.
I want to make a server and client side WITSML (for Oil & Gas Wells Drilling Data Send/Receive). There are some SDKs here: (WITSML api library for .Net / C# client apps?). I surfed though the internet, but i have not been found any code example or guide to use them.
==>.Are There any code example to develop a WITSML and/or WITS server and Client side software in C#?
Thank you in advance.
Without knowing what column EventDate is (we can guess, but that's dangerous!) we can't tell you.
However, if EventDate is a DATETIME type, how about
CAST(EventDate ASDATE) = CAST('NOW'ASDATE)
(Disclaimer - I don't know Firebird so using 'NOW' to get current date/time seems a bit weird - converting a string literal NOW to date time? I'd be more used to CAST(NOW() AS DATE) or CAST(NOW AS DATE) ... )
createtable PendingQueue (
cnstraint pk_pending_id nonclusteredprimarykey(id));
createclusteredindex cdxPendingQueue on PendingQueue (DueTime);
insertinto PendingQueue (DueTime, Payload)
values (@dueTime, @payload);
@batchsizeint = 100,
@retrysecondsint = 600assetnocounton;
set@now = getutcdate();
with cte as (
from PendingQueue with (rowlock, readpast)
where DueTime < @noworderby DueTime)
set DueTime = dateadd(seconds, @retryseconds, DueTime)
output deleted.Payload, deleted.id;
Specially see this line set DueTime = dateadd(seconds, @retryseconds, DueTime)
How this line instruct sql server to retry the update data again after 10 minute if fail to update data first time. this is not clear to me. please some one explain if you understand properly. thanks