Use of temporary tables in SQL Server

Http://www.cnblogs.com/chongzi/archive/2011/01/19/1939106.html

--The stored procedure writes the results of multiple table joins to the staging table, and then queries the  temporary table contents through the cursor --to determine if the temporary table exists if    object_id ('  Tempdb.. #TmpTable ') is not NULLDROP TABLE #TmpTableSELECT  A.[a1],a.[a1],b.[b1],b.[b2]into # Tmptablefrom a aleftJOIN on a.a1 = b.a1

Manipulating cursors

DECLARE @orderId NVARCHAR( -),@customerId NVARCHAR( -),@employeeId NVARCHAR( -)DECLAREMyCursorCURSOR  forSELECTO.orderid,o.customerid,o.employeeid fromOrders asoOPENMyCursorFetch Next  fromMyCursor into @orderId,@customerId,@employeeId while @ @fetch_status=0 BEGINPRINT @orderIdPRINT @customerIdPRINT @employeeIdFetch Next  fromMyCursor into @orderId,@customerId,@employeeIdENDCloseMyCursordeallocateMyCursor