Database

Quite right. But any program worth its salt would be validating the content as it goes through them. And if there is not a blank row at the end then a complete line of data will be missed.

Sorry, Duplication was a mistake. Thank you for your note.

Voulez-vous gagner un compte Netflix gratuit, de l’argent et même des supers cadeaux gratuitement ? icipourgagner.fr est un site des jeux concours fiable est gratuit qui vous donne la chance de participer et de gagner des bons d’achat… Vous pouvez aussi s’inscrire dans le site pour pouvoir jouer à la roulette de chance pour gagner de l’argent. Il suffit de cliquer sur le lien mentionné ci-dessous pour pouvoir accéder au site : https://icipourgagner.fr/

Member 13325846 wrote: 1- Which free database is the best to use for real-time data storing and querying (at the moment of storing) based on your experience or knowledge? SQLite, in memory database storage would be my choice. Stores db in memory, instead of disk. SQL Server has the same option. ..but both not real time, just really, really fast. Anything on Windows is not guaranteed real time, by technolgy. If you need real time, reseach QNX or the likes. Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Mou_kol wrote: i read about ROWLOCK & UPDLock but still not clear MSDN pretty clear. Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

It doesn't. It simply updates the DueTime column in the PendingQueue table, and returns the Payload and id columns of the affected rows. There must be some other code which processes and removes the record from the PendingQueue table which you haven't shown. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

I take this point, I restructured my schema to just have 1 table per type for the time being, I was just trying to have less tables and then ran into this anti-pattern. Thanks for the input.

You most likely need to use a set of UPDATE statements in order to use different random values.

I looked a little and found such a site with sql interview questions https://geekinterview.net Maybe it will help, but there are many website where You can find example questions.

I usually divided the INSERT into DB and then ReQuery for the opened recordset. However, did you check the returned recordset from pCmd->Execute();

It's usually preferable to store the files in the file system, and store the paths in the database. But you might want to consider using file tables or filestream access instead, if they're available on your server. Binary Large Object (Blob) Data (SQL Server) - SQL Server | Microsoft Docs[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

1. Don't type in all CAPS. It makes it look like you are yelling and is considered rude. 2. You have not asked a question. 3. All you have to do is write code to do this. When you update inventory then update the other fields too. Social Media - A platform that makes it easier for the crazies to find each other. Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.

There are lots of 3rd party products that can source control your database. This is one of them that I have used, SQL source control | ApexSQL[^] Social Media - A platform that makes it easier for the crazies to find each other. Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.

Take a look through these and see if there is a structure that meets your needs. http://www.databaseanswers.org/data_models/[^] Take note of the primary (PK) and foreign keys (FK) used to normalise the data. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP

Now I feel sorry for missing this question. Normalization is one of the things you have to learn, and not just for databases. It will give you more insight into data. Let me stress that again, you want to master this, it is what makes a master. Can you give me a real life analogy for your abstract question? Otherwise, I'd just have to reply with the rules which you already know. And BCNF comes after 3NF; if it in 3NF, it not guaranteed to be BCNF, so answer one falls. Leaves you with three. Also, 3NF and BCNF rather close - if you can answer it, you master it. Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Just use the CONVERT function, SELECT CONVERT(Sales_Order_Ship_Date , Date); Social Media - A platform that makes it easier for the crazies to find each other. Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.

Not a pro in here, but did some research and it seems like that this link might be helpful: Generating REST APIs from data classes in Python | AWS Compute Blog[^]