Common Database Questions - 4GuysFromRolla.com

Common Database Questions

Post a Database Question to the Messageboard

How can I return the rows from a SELECT statement in random order?
[Answer]

How can I create a stored procedure to select the top N records? For example, I'd like to be able to do: sp_GetTopRecords 25 and select the top 25 records.
[Answer]

This might be simple for you, but I just can't figure it out. I have built a large database with several categories of products. What code do I write to make a list selection in one box (main categories) bring up another list box with items only associated with the intial category selected (I hope that made sense.)?
[Answer]

I get errors when inserting a text string that contains an apostrophe... why is this?
[Answer]
[Answer @ ASPFAQs.com]

How can I display database image files through an ASP page?
[Answer]

How can I view the contents of an Excel Spreadsheet through an ASP page?
[Answer]
[Example Code on ASP101.com]

I am needing to design a site with varying security levels for various users. What should my data model look like for this project?
[Answer]

Can I dynamically name my Recordset objects?
[Answer]

I am having some problems with the performance of my database queries. Are there any tips you can give?
[Answer]

Can I pass a comma-delimited argument list to a stored procedure? For example, I'd like a stored procedure like:

CREATE PROCEDURE sp_DeleteStuff(@DeleteList varchar(255))
AS
  DELETE FROM TableName
  WHERE ID IN (@DeleteList)

Is this possible?
[Answer]

I need to get the value of an Autonumber field (in MS Access) upon a record insert. How do I do this!?
[Answer]

In my Access database I have table names with spaces. In ASP, when I try to write my SQL statements, having spaces in the table names throws things off. Help!
[Answer]

When I use the .RecordCount property to count the number of records in my recordset, it returns -1. Why?
[Answer]

Should I use a System DSN or a DSN-less connection to connect to my database?
[Answer]

I need a SQL query that will check to see whether a table exists. How do I do this?
[Answer]

How do I read data from a database and store the information into variables?
[Answer]

How do I sort a recordset based on the Autonumber field (or any field, for that matter)?
[Answer]

How do I list the tables in an Access database?
[Answer]

How do I check what ADO version I have? Specifically, I want to see if I'm using ADO 2.1.
[Answer]
[Answer @ ASPFAQs.com]

Is it possible to create a new table in your database using ASP?
[Answer]
[Answer @ ASPFAQs.com]

So far I've only worked with access when codin my asp pages. I want to move up to MSSQL server though, how much different is it from Access? Is it quick to pick up? Does my ASP code need to be change in any way?
[Answer]

How do I delete rows from a recordset?
[Answer]