Search results for query: *

Is there a way I can use javascript to query from a simple text-based tab-delimited database using SQL, but without any special support like MySQL, Oracle, SQL Server, etc.? I basically just want to be able to query some info so I can dynamically insert text into my webpages. I just need to...

I have a query with one column and 937 rows. I have another query with the same one column and 595 rows. I want to query the difference of these queries, but I am having a heck of a time finding the syntax to do it! I'm using SQL Server 2000 and it's not liking the DIFFERENCE function...

This one may be a little hard to explain, but here goes - I have a table APPS and table MONTH. MONTH is a subset of APPS that contains records with a date in the month of, say, January and in 2002 (the month of choice will vary). There's a part in the query I'm trying to build where I want to...

I have a table: APPS that lists data for applications for a number of applications including its date. I'm trying to build a query to list number of applications per month by month. I have a query listing the 12 months, and I can make other queries to find count the number of apps per month...

I'm getting syntax errors about missing operators when I use a query that is similar to: SELECT CASE WHEN (column1 > 0) THEN '1' WHEN (column1 = 0) THEN '0' WHEN (column1 < 0) THEN '-1' END AS field1 FROM table1 It works fine in MS SQL Server, where I first wrote the query, but...