Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the ...
My tinkering with ASP.NET got me to wondering if you can do named parameters directly in SQL from within classic ASP/ADO. I can't seem to get it to work, it seems to ALMOST work but not quite. Example ...
I'm trying to figure out how to use the SQL where/in syntax with a paramterized query. For instance let's say I'd like to run the following query: select * from customers where custid in (1,2,3); I ...