SQL For .NET Programmers

Is now available as an eBook for your Kindle reader.

Get it at Amazon today!

Recent Posts
Calendar
October 2008
S M T W T F S
« Sep   Nov »
 1234
567891011
12131415161718
19202122232425
262728293031  

Archive for October 7th, 2008

Temporary Tables – SQL For Programmers

other-076 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.

Read the rest of this entry »