> to build a SQL string and execute it, you'll get no
> speed/efficiency benefit at all, in fact it will probably
> be slower.
This is true, but if you use stored procedures exclusively for all database
access, you may be able to tighten your database security considerably. That
said, if you're using MS SQL Server, you might want to use the WITH
RECOMPILE clause for this stored procedure, which I think would prevent the
reuse of inappropriate execution plans.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
