Temp Tables - Forums & Discussions

Local vs Global temp tables - When to use what?

It sounds like you are getting into an OLTP mode now. Reading up on database warehousing will definitely help you. source

What's the difference between a temp table and table variable in MSSQL?

Consider also that you can often replace both with derived tables which may be faster as well. As with all performance tuning, though, only actual tests against your actual data can tell you the best approach for your particular query. source

Can I insert into a temp table the result of a stored procedure plus another value?

Any way to do this without manually creaiting the table first? Often times a proc is a combination of several tables and it can get quite messy to try and recreate this. source

How can my application benefit from temporary tables?

I've used them in the past when I needed to create evaluated data. That was before the time of views and sub selects in MySQL though and I generally use those now where I would have needed a temporary table. The only time I might use them is if the evaluated data took a long time to create. source

In SQL Server 2005, can I do a cascade delete without setting the property on my tables?

My suggestion is to go ahead and write a script that will add the on delete cascade to each relationship in the database while exporting a list of modified relationships. Then you can reverse the process and remove the on delete cascade command on each table in the list. source