Adam,

http://dev.mysql.com/doc/mysql/en/innodb.html 

You can use this instead of MySQL's own MyISAM stuff. However I think most people using MySQL use MyISAM and I also think that most ISP's (at least mine) does...

Oracle started this sort of thing by bringing Java into the database and many thought that it spelled the end of PL/SQL. It did not.

Yes, they've smartly chosen JSP for...

hope this clears thing up 😉

Sure, blame it on my language barrier

Unless of course there is a set based method to do multiple inserts into a table that would include an incrementing value

What exactly do you mean here?

Piggy-backing on Gabor, this might be interesting:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

And while you're at Erland's site, read also this http://www.sommarskog.se/arrays-in-sql.html

It might be just me, but I'm not sure what you're trying to do. Can you provide the information mentioned here?

http://www.aspfaq.com/etiquette.asp?id=5006

Steve, there were several articles about that in the DB2 magazine (to which you can subscribe for free, I think). IIRC, the major article was published in the 3/2004 edition...

http://www.sqlservercentral.com/columnists/chedgate/clusterthatindex.asp

http://www.sqlservercentral.com/columnists/chedgate/clusterthatindexparttwo.asp

http://www.sqlservercentral.com/columnists/chedgate/clusterthatindexpart2.asp

gives a reasonable discussion of that topic.

Read the URL I've posted. Style 101 is not considered a save date format. You should rather use 112 or 126.

Good luck and hopefully all users will remember to copy and paste from Excel.

They should look at CLR as an efficient alternative for logic that cannot be expressed declaratively in the query language

...and of course, each developer will rather use a...

In that case, you might want to add

SELECT DATEADD(d,DATEDIFF(d,0,getdate()),0)

SELECT CAST(SUBSTRING(CAST(GETDATE() AS BINARY(8)),1,4) + 0x00000000 AS DATETIME)

SELECT CAST(CAST(SUBSTRING(CAST(GETDATE() AS binary(8)),1,4) AS INT) AS DATETIME)

SELECT CONVERT(DATETIME,CONVERT(CHAR(8),GETDATE(),112))

SELECT CONVERT(CHAR(8),GETDATE(),112)

SELECT CAST(CAST(GETDATE() AS VARCHAR(12)) AS...

You cannot declare a variable of type text!

And I think your approach here is prone to errors. How will you catch all exceptions when user use this way to upload...

Another way would be:

cust_ord_due  = dateadd(d,0,datediff(d,0,getdate()))