This simple example shows you how to create and use temp tables in Microsoft SQL Server 2008.
First we have to create the temp table. The difference between regular tables and temp tables is to use the # before the table name. The syntax is the same:
create table #tempTable(keyword nvarchar(max), productNo nvarchar(30), anotherValue nvarchar(max))
After the temp table is created, we can put some data into it:
insert into #tempTable (keyword, productNo, anotherValue)
values ('test', 1234, 'somewhat')
After the data is in the temp table, we can use regular select statements:
select * from #tempTable
The result is:
keyword productNo anotherValue
test 1234 somewhat
