What about THX 1138?

And I'll second an earlier post about Bladerunner.

For those worried about the overall tool performance (i.e. slow, RAM hogs, etc.) you need to concider the fact that these tools, being built on a non release version of...

Good article and comments.

Another way that applications will be able to mitigate the response issue (or lack thereof) will be delivered with .NET 2.0 (check out the article link). Though...

There is a serious problem with using the encrypt() function. This has got to be one of the simplest algorithms on earth to crack. All it really prevents are non-technical...

A quote from Microsoft:

"Stored procedures are supported only against SQL Server data sources."

This is taken from "External Data and Transact-SQL" http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_3164.asp

You may be able to get around this, and...

This function takes rockmoose's post one more step further (more of an internationalized step). You may not need to go this far, but food for thought.

CREATE FUNCTION dbo.GetDayOccurance (

 @day TINYINT,

 @yr ...

I have a post in the other thread for this topic that should fit the bill for you. (message id = 106587)

There is an article on this at 15 Seconds (http://www.15seconds.com/Issue/010308.htm) that will explain it fairly well (it was written for SQL 7 but this should work for 2000 as...

Thanks for the quick response.

This would work if the client machine has the SQL Server Client suite installed, but at this time there is no desire to do so.

I should have held off on posting this question. I have worked through and found the problem and solved it.

VS.Net does not...

If I knew that the user was going after a column that was a Datetime value, using convert would be perfect. But the application will not be able to determine...

Thanks brendthess, that took care of the milliseconds for SQL Server. I tried to adapt the code to handle microseconds for DB2, but have begun to run into an accuracy...

Here is, more precisely, the problem.

If a Select is issued from a VB application and you do not know the column data types, those that return as a Timestamp...

Thanks for the responses. I have briefly looked at setting up my own control in an attempt to get around this problem with the text box. What I was really...

I suppose I'll put my 2 cents in on this one. For both of you EOJRR1 and salim, AVOID DPROP like it was the plague (Unless your company wants to...