Some of the queries in SQL may require a temporary holding place in the memory for doing some logical process.For example, select certain number of rows from a table and remove/update some rows within this based on some condition.This may require a temporary variable or table in SQL server 2005 to achieve this task.
There are four ways we can have temporary recordset or a dataset in SQL server.
1) Temporary Table Variables
2) Temporary Tables
3) Derived Tables
4) Common Table ex-pressions (CTE)
0 Responses
Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.