Viewing 15 posts - 1 through 15 (of 17 total)
SQL Reporting Services looks very interesting. Here's a good article and link to Microsoft's site. Although I haven't used it yet, it appears to be very user-friendly and...
December 23, 2003 at 9:31 am
Good article. Informative, especially for beginners who are starting to deal with this.
One suggestion: In the second to last paragraph you talk "SQL Server's built-in functionality for optimistic concurrency,"...
December 19, 2003 at 11:29 am
Yeah, well sometimes I wonder if these guru guys have jobs or if they just sit around posting all day. 😉
December 15, 2003 at 8:05 am
Someone asked about the theory behind XML. I'm not aware of any formal/mathematical theory, but I guess there is one related to the hierarchical, tree-structure of the way the...
October 23, 2003 at 9:37 am
Let me start by saying that XML has been overhyped, and MS is guilty of much of that. Since the big XML push of several years back, the first...
October 22, 2003 at 11:29 am
Access 2002 uses extended properties in SQL to store meta data about the access application.
Are you using SQL 2000? I don't think SQL 7 had extended properties - not...
October 15, 2003 at 11:36 am
There is no Java.NET - Microsoft has released a Java-like language for the .NET platform called J# (J Sharp). It was intended as an upgrade path from their...
October 9, 2003 at 12:28 pm
This has to do with boolean logic. I took a logic course in a long time ago and I can't remember all the details but basically when you are...
October 8, 2003 at 10:54 am
I've never gotten the debugger to work successfully from QA. Good luck to you if you can do it! There's always good ole Print statements... 🙂
However, I have...
October 6, 2003 at 10:18 am
To answer you second question first:
Static sql (such as a stored procedure) has a pre-compiled execution plan and thus can be more efficient.
To your first question:
My take on this is...
October 6, 2003 at 10:15 am
How well does it work? Also - do you know if the company is legit? (I don't want to install spyware...)
October 6, 2003 at 10:08 am
You could accomplish this by using a user-defined function (udf) as the default value. The udf would have to look up the most recently added value for the AccID...
October 6, 2003 at 9:50 am
I agree that Flip charts work well. One additional low tech enhancement is to use the flip charts from 3M that are basically giant sticky notes. You can...
October 2, 2003 at 8:24 am
Here's a few links that may help. The first one actually compares SQL/MSDE to JET:
October 2, 2003 at 8:09 am
Just my 2 cents...
I have developed using Access for over 6 years and mostly agree with what has been posted so far.
However I would say that I have...
October 2, 2003 at 8:00 am