Temporary Tables - SQL For Programmers
You may think that you don’t need a temporary table. But if you’ve ever retrieved data from your database or retrieved data from a table and put it in a list of some sort simply to process it further with your code, you need to learn about temporary tables.
I’ve also needed to use Temporary Tables to simulate arrays in my stored procedures. You can pass in a comma delimited list and then have your stored procedure process the list into a temporary table, making the information easier to evaluate.
If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
