Hi Kevin,
> -Does VistaDB support stored procedures?
Not in 2.0. We plan to host the CLR in 3.0, due out in early 2005.
This will work much like Yukon.
> -Does it support temp tables?
Yes. You can create in-memory tables and physical temporary tables.
Just so you know, VistaDB is much closer to Jet than to the MSDE
> -Does it support UDFs?
No.
> -How closely does it support the SQL-92 standard?
> In particular, I have instances where I return a scalar result from a subquery
Quite closely. And yes, you can use scalers.
> It does seem like a good alternative for instances where one wants a
> small footprint - and if it supports those things, I might be able to use it.
That's exactly the goal: VistaDB is designed to be an alternative to Jet.
Just so you know, we've been working on VistaDB for 3+ years (4 guys at
our company) and its based on many years of experience working on commercial
data engines. The VistaDB eval we have for download is full featured so you
can see first hand if VistaDB would be a good solution for some of your projects.
Anthony Carrabino
www.vistadb.net