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 ...
cmd.Parameters.Add (P);</pre>The constructor for SqlParameter is documented as infering the type when you use the signature that accepts the name and value. This may be failing somehow and causing a ...
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 ...