ADP - VBA Functions vs SQL UDFs
Posted on 2006-06-13
I've moved most of my databases now to ADP as the performance with the SQL backend is superb, though one of my dBs has a large number of VBA functions programmed within it. These VBA functions were used within update queries within the db when it was a mdb, and I'll need to use them in the same context within the ADP. Anyone able to help out on the below questions on this or provide any useful tips?
- Can VBA functions be accessed from a SQL Server Query/SP?
- Are there any performance benefits from converting them into SQL UDFs?
- As the VBA functions are fairly large and complex, is it fairly easy to convert them into T-SQL based UDF?
Thanks for any help or guidance,