RVe20YzK

1-- Delete Table If Already exists
2If(OBJECT_ID('tempdb..#MyTable') Is Not Null)
3Begin
4    Drop Table #MyTable;
5End
6
7-- Create Table
8CREATE TABLE #MyTable (
9  MyColID INT PRIMARY KEY
10);
11
12-- Insert Data
13INSERT INTO #MyTable VALUES (2);
14
15-- Select Data
16SELECT * FROM #MyTable 
17
18-- Find in TempDB
19SELECT Name 
20    FROM TempDB.dbo.SysObjects
21    WHERE Name Like '#MyTable%'