I turned up something in a search I wanted to confirm - that I can't do the following:<BR><BR>INSERT INTO table_a<BR>(col_b, <BR> col_c)<BR>VALUES<BR>('blah',<BR>SELECT id FROM table_b WHERE name IS ...
Stored procedures can speed up your code by reducing trips to your database -- even if you only have one SQL statement to execute. Here's how to speed up your application (and how to simplify your ...