局部临时表

　　局部临时表有两个特点，一是表名以'#'号作为前缀，二是它只对创建它的会话在创建级和调用堆栈内部级(包括内部的过程，函数，触发器和动态批处理)可见。局部临时表的应用场景是，当需要把中间结果临时保存起来，以便供以后查询这些临时数据的时候使用。下面是创建局部临时表的示例代码。

USE TSQLFundamentals2008;GO-- 局部临时表IF OBJECT_ID('tempdb.dbo.#MyOrderTotalsByYear','U') IS NOT NULL DROP TABLE dbo.#MyOrderTotalsByYear;GO-- 创建局部临时表SELECT YEAR(orders.orderdate) AS orderyear,SUM(orderDetails.qty) AS qty INTO dbo.#MyOrderTotalsByYearFROM Sales.Orders AS ordersLEFT JOIN Sales.OrderDetails AS orderDetails ON orders.orderid = orderDetails.orderidGROUP BY YEAR(orders.orderdate);-- 在当前会话中，从局部临时表中查询数据SELECT * FROM dbo.#MyOrderTotalsByYear;

查询结果：