Category: Tips
-
Run a task every x-minutes with Windows Task Scheduler
The task must be configured in two steps. First you create a simple task that start at 0:00, every day. Then, you go in Advanced… (or similar depending on the operating system you are on) and select the Repeat every X minutes option for 24 hours. Double click the task and a property window will show up. Click the Triggers tab.…
-
How to select N random records from a SQLite table
If you want to select N random records from a SQLite table, you need to change the clause as follows: select * from tableName order by RANDOM() limit N For example, to select 5 random customers in the customers table, you use the following query: select * from customers order by RANDOM() limit 5 Some…
-
How to select N random records from a DB2 table
If you want to select N random records from a DB2 table, you need to change the clause as follows: select * from tableName order by rand() fetch first N rows only For example, to select 5 random customers in the customers table, you use the following query: select * from customers order by rand()…
-
How to select N random records from a PostgreSQL table
If you want to select N random records from a PostgreSQL table, you need to change the clause as follows: select * from tableName order by random() limit N For example, to select 5 random customers in the customers table, you use the following query: select * from customers order by random() limit 5 Some…
-
How to select N random records from a SQL Server table
If you want to select N random records from a SQL Server table, you need to change the clause as follows: select top N * from tableName order by newid() For example, to select 5 random customers in the customers table, you use the following query: select top 5 * from customers order by newid()…
-
How to select N random records from a MySQL table
If you want to select N random records from a MySQL table, you need to change the clause as follows: select * from tableName order by rand() limit N For example, to select 5 random customers in the customers table, you use the following query: select * from customers order by rand() limit 5 Some…
-
How to select N random records from an Oracle table
If you want to select N random records from an Oracle table, you need to change the clause as follows: select * from ( select* from tableName order by dbms_random.value ) where rownum <= N; For example, to select 5 random customers in the customers table, you use the following query: select * from ( select* from customers order by dbms_random.value ) where rownum <= 5; Some Oracle tools you can…
-
About “Unable to load odbcji32.dll”
Sometimes, you may get this error: To solve this problem, you can see this page: http://answers.microsoft.com/en-us/office/forum/office_2016-access/unable-to-load-odbcji32dll/de67abd0-f4d8-40af-8e5f-1922b8393d7e .
-
missing msvcr110.dll
The Program can’t start because MSVCR110.dll is missing from your computer. Try reinstalling the program to fix this problem. See this page: http://answers.microsoft.com/en-us/windows/forum/windows_8-winapps/the-program-cant-start-because-msvcr110dll-is/f052d325-3af9-4ae5-990b-b080799724db
-
Download Microsoft Access Database Engine (64-bit)
Short answer: the 64-bit build of the Microsoft Access Database Engine 2016 Redistributable is the file AccessDatabaseEngine_X64.exe. You can download it from Microsoft. Before you install it, read the second half of this page: if you landed here because of “Provider cannot be found. It may not be properly installed” or “Data source name not…