Archive for October 7th, 2008
Temporary Tables – SQL For Programmers
October 7th, 2008 | 
Author: 
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.
Other Related Items:
Microsoft SQL Server 2008 T-SQL Fundamentals (PRO-Developer)Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance—including exercises and code sa... Read More >
Age of Empires II GoldMicrosoft Age of Empires II: Gold 2.0 Win32 English North America CD DVD Box Gold
Mini Roller Coaster by AnatexMini Rollercoaster by Anatex: 8 x 10 x 12 The Mini Rollercoaster helps a child develop visual tracking, eye-hand coordination, and shape/color recognition. For ages 3+.
Manufacturer's item # MN2594
Posted in SQL For Programmers | 
Tags: create table, sql, temp table, temporary table, tsql | 
1 Comment »
