Viewing 5 posts - 1 through 5 (of 5 total)
Basically the architecture of what I'm trying to fit this into -- pretty much everything happens in SQL inside stored procs, so at this point I'm not really allowed any...
May 12, 2011 at 3:12 pm
I've looked at that and SET PARSEONLY ON; both seem to work fine interactively but I can't get them to work inside a function.
May 12, 2011 at 11:25 am
I've found that the use of Access functions will dramatically decrease performance of upsized apps. If you use things like IIF (a favorite, apparently) in your queries, all the data...
March 18, 2005 at 2:54 pm
Unfortunately, you get an error trying the "Use" statement inside a stored procedure, so it looks to me like the only way to do it is via dynamic SQL (bleah).
February 4, 2005 at 9:46 am
The one reason I'm forcing myself to learn C# is that documentation can be included in the source code, and VB doesn't support this. Still, case-sensitivity and forced ending characters...
June 24, 2004 at 2:48 pm