Search results for query: *

Hey there, I got a table which has around 2 millions inserts each day (which means more than 20 inserts each second). Also, this table has a timestamp field. What will happen to this query? Will it run endlessly? SELECT COUNT(*) FROM my_table WHERE TS_FIELD > '2016-02-01 00:00:00.000000'...

Hey there, I have a form that search for a string I enter in all the forms/modules, the queries and the reports in my Access database. It returns me the name of the Access objects in which the string has been found. So, I can see where a certain field name or table name or query is used...

Hi, I just wanna know if it is possible include a parameter or variable to a query. The code below is not functional (and not useful at all... lol), it's just to give you the general idea behind my question. CREATE OR REPLACE FUNCTION Func_Test(P_STRING as VARCHAR2) RETURN INTEGER As V_Cnt...

Hi, I got a list of over 1400 amounts being between -500 000 000,00 and 500 000 000,00. The cells are in number format. I wanna do a sum of those amounts. And I already know I should get an answer of zero. But Excel gives me this answer : -0,0000373721122741699. In fact, if I do a sum on the...

Hi, I got an Excel 2003 worksheet that I want to fill with data from Oracle. My query is on 5 fields, I want to display 4 of them but, the fifth one is only for some work and calculations that updates the recordset. I don't want the fifth field to be displayed. So, I want to hide, remove or...

Hi, First, both PCs have Windows XP Pro. Here's my situation : I got 2 PC connected to a D-Link router and this one is connected to my cable modem. The PCs have no problem to access to the Internet. Also, both have shared folders. The PC "A" "sees" all its shared folders AND the shared...

Hi, I would like to know what is 'behind' the rnd function. I mean the law that is used to get randomized numbers. I'm using the randomize function before the rnd and I know how to use them... but what is the code for rnd function?? Must I really trust this function? Is it based on a...

Hi, I need some help about creating text files. I use Windows 98 and I want to create text files in different directories. These directories are &quot;under&quot; the program directory. I was thinking doing this way : #include <stdio.h> #define N 300 void main(void) { FILE *fp; /*...