Question: I have a table like this one: Day_Period_Money (daydate date, period number, amount number); Here is an example of some data: daydate period amount01/01/99 1 1001/01/99 2 2001/01/99 3
Question: I have a table that contains numbers defined as varchar. How do I convert from varchar to number? Answer: Try using the CONVERT function. If that is not an
Question: I have this real cool function to determine if a Form is Open which works fine in Access 97, but not in VB 6.0 because it does not support
Question: I am creating a data warehouse and need to SELECT and INSERT data across servers using SQL Server 6.5. Is there any way I can code this in my
Question: How do I perform a word search in SQL? I want to find all rows containing the word “time” by itself and not any rows containing “time” as part
Question: What is the SQL standard for concatenation? Answer: In SQL Server, you can do something like SELECT “Me” + “You” gets you MeYou In Oracle, I believe the symbol
Question: Since there are no pointers in Java why is there aNullPointerException? Answer: It is a bit misleading to say that Java does not have pointers.Reference variables are very similar
Question: I am in the process of creating an n-tier database application and am stuck at storing images to the SQL Server database. Any help would be appreciated. Obviously, I
Question: I have written an ActiveX EXE. that handles Batch Reporting requirements on a large amount of data. Even though it is an Out-of-Process “server”, it still seems to execute