Search results for query: *

Hi, I'm wondering, how would you get the identifier ( or the primary key) of the recordset you just inserted without doing a SELECT statement that attempts to check it up by its other characteristics (in Oracle 8)? The reason why I ask is because the recordset I just inserted might not...

I'm using .asp files to execute sql statements to modify a MS Access database.&nbsp;&nbsp;I tried some very simple statements only to find that somehow I can't execute them.<br>The statements are as follows:<br><br>strSQL=&quot;ALTER TABLE ADD Column_Name smallint DEFAULT 0&quot;<br><br>For some...

Hi,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I've been programming in asp fairly often now and I pretty much get how to run everything.&nbsp;&nbsp;However, I still don't know what's the difference between function and sub except for the fact that subs can't be used where functions are...

Thanks for the response.&nbsp;&nbsp;It really helped and I appreciate it.

Okay, I found out my problem is actually a conflict with group by and order by statements.&nbsp;&nbsp;I'm wondering if any of you could help me with this problem.&nbsp;&nbsp;The code that I now have is (which is wrong):<br><br>SELECT TOP 10 item, COUNT(item) AS cnt<br>FROM Items AS I1<br>WHERE...

The code I have provided in the previous post is kind of inadequate.&nbsp;&nbsp;I'm wondering what's wrong with this code now:<br><br>SELECT TOP 10 *<br>FROM Items<br>WHERE Date BETWEEN StartDate AND EndDate<br>GROUP BY Item<br>ORDER BY COUNT(*)<br><br>Basically the database contains a lot of...

I'm wondering, how would you use the TOP keyword to find the records that are top 10 in the number of times they appear in the database?&nbsp;&nbsp;I know it is very easy to find the top 10 simply by looking at one of the field values but how would you do it by ranking them with the function...