Why not use MSDE?  There is an installation folder somewhere on the MS Office2000 CD.

This way you wouldn't have to butcher your existing code.

I've found that MS Access (running the...

CREATE PROC qryOrderInfo AS

SET NOCOUNT ON

SELECT orders.*,

products.ccode,

products.cname,

products.cprice,

oitems.numitems,

customers.*

FROM customers INNER JOIN orders

ON customers.custID = orders.ocustomerid

INNER JOIN oitems

ON orders.orderid=oitems.orderId

INNER JOIN products

ON oitems.catalogID = products.catalogID

qryOrders

CREATE PROC...

If a field in your recordset object contains data then use ASP to write out the html <input..> tag with a READONLY attribute and VALUE attribute as picked up from...

So basically

if(rs!FirstName){

 write("<input type=text name=txtFirstName READONLY value=\"" & rs!FirstName & "\">");

else

 write("<input type=text name=txtFirstName>"); 

I had something similar and had to define a table as follows:-

DECLARE @tbl TABLE (SerialNumber VARCHAR(20) COLLATE SQL_Latin1_General_CP1_CI_AS PRIMARY KEY CLUSTERED)

I also had a problem when the "default language" on...

Are your databases on different servers?  If they are then check the collations and character sets.

If they are on the same server then why not use a straight select?

If database...

I would do processing like this in one asp page.

The submit button has a value, or if you are using <input="image"....> a hidden field has a suitable value.

The page always...

There are two ways that I would approach this, and both of them involve scripting.

1. Use the generate script option on your objects.

SQL Server will generate the usual MS verbosity...

The trick is to sort the wheat from the chaff!

I've lost count of the number of technologies/technology companies that were going to be the next big thing, but after a flurry...

It is not really clear from your code what you are trying to do.

The settings of your SQL Server will affect how NULL values are interpretted so be careful, otherwise...

IF isnumeric(@s)= 1 AND PATINDEX('%[A-Z]%',@s)=0

     PRINT 'All Number'

ELSE

    PRINT 'NOT All Number'

This is a weird one.  At first I thought it was interpretting your value as a hexadecimal number but SET...

Sorry, I forgot to add.  Splitting the table into more than one by columns is vertical partitioning.

If your users tend to search for last months transactions then I would consider...

I had this problem where I had to get transactions from 15 countries on a monthly basis.

My solution, pre-analysis services was to create specific summary tables that pre-aggregated the data.

For...

Personally I couldn't give a damn about the "don't use capitals" issue.

For the pedants out there I do understand about case sensitivity.

What I care about is whether or not there...

It could have been nasty and obviously the exec wanted him skinned alive.

Fortunately IT manager took the view that he should be the one to discipline his own staff so...