I need some general advice. (My natural language is Portuguese).
I need to do a small Windows desktop application to fill (by hand) a single table with, say, a maximum of one thousand records of some 20 fields for later manipulation.
About 15 years ago I have done a database application in Access 2003 whose tables were separately stored (same folder) without a SQL server. I would like to stay away from Access and use Visual Studio Community and, also, stay away from a SQL server or the need to have it installed in the computers where the application will run.
I suppose that to crate a table in a form must not be complicated (I have already played a little bit with that) but I am at a lost about storing the table on disk without SQL database/server. All examples I found in the Web involve SQL servers.
Simplifying, I need to make a standalone application able to create, store and read a separate datafile. Saving the table in Excel format or similar would be acceptable because importing some data from excel could eventually be interesting. The application final output would be some ASCII file with delimited data but this file is not supposed to be read by the application.
At the moment I am flying around without a place to land. Any help would be greatly appreciated.
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
I have some confusion about lock (ROWLOCK ,UPDLock AND xlock). i want to know the difference among these locks. where to use UPDLock, when to use RowLock and when Xlock with a example for better clarification.
BEGINTRANSACTIONSELECT @ID=RowID FROM MyTable WITH (ROWLOCK, XLOCK, HOLDLOCK) WHERE ID=6822
In the above sql rowlock and XLOCK both use as a result from other session records 6822 could not be read or modify. XLOCK alone is capable to lock the rows....so why one should use ROWLOCK & XLOCK together ?
if i use only xlock & HOLDLOCK then it will not serve the purpose ?
2) Tell me with example what is the difference between ROWLOCK & UPDLOCK ?
ROWLOCK prevent other session to modify data and UPDLOCK does the same thing. so what is the difference
between ROWLOCK & UPDLOCK ?
Please anyone explain these difference with example as a result at my end i can run the example code and understand.