[dba-SQLServer] Access BE to SQL

Thanks, that is a really useful observation.  I thought that the logic for generating paged data sets where handled mostly at the front end, and didn't realize that BE tools (can) have these functions built in.  
 
Steve Capistrant
Symphony Information Services
scapistrant at symphonyinfo.com
www.symphonyinfo.com
Main: 763-391-7400 ext 801
Toll Free: 888-357-1373 ext 801
Direct:  612-237-0075

________________________________

From: dba-sqlserver-bounces at databaseadvisors.com on behalf of Stuart McLachlan
Sent: Thu 10/5/2006 10:30 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Access BE to SQL



On 5 Oct 2006 at 22:40, JWColby wrote:

>
> One thing you might want to consider is moving up to SQL Server 2005.  That
> has the full on VB.Net as the scripting language right inside of SQL Server
> (or so I am told).  While VB.Net and VBA might not be a close match, for the
> kinds of things you might run into it might way better than what is
> available in SQL Server 2K. 

Especially since he wants to use paged sets of data.  That is a real PITA in 2000, but is much easier in 2005, not least because
of the new RowNumber() and Over.

--
Stuart McLachlan


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com