Search results

What data type should I use if I have no idea how much data will be entered? And is there anyway of avoiding all the trailing white space if I enter, e.g. varchar(50). Thanks in advance.

Hi, is there any way to do an order by, but specify that a particular value is listed last, or first. E.g. ORDER BY t_name ASC ... but feature Simon first and not with the other names beginning with 'S' Thanks.

Hi, is there anyway to perform a query and have it order by the count? I thought it was possible but keep getting an error. I'm using the following: SELECT st_term, COUNT(st_term) AS QueryCount FROM tblSearchTerms GROUP BY st_term ORDER BY QueryCount Any help would be *hugely* appreciated...

Hi, I have a db (MS Access 2000) that currently has 37 tables in it, each table holds about 30 rows and 72 columns of data. I need to basically create the entire database again but change all the column names slightly so that they still hold the same information but with different column names...

Hi, I've recently taken on a new client with exisitng sites running off one database and I need to move the sites to a new server, including the database. The old company that the client was using have provided me with the site files and the database as a .bak file. I am a total newbie with...