[dba-SQLServer] Access BE to SQL

Stuart McLachlan stuart at lexacorp.com.pg
Thu Oct 5 22:15:01 CDT 2006


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





More information about the dba-SQLServer mailing list