Temp table in sql

what is

CREATE TABLE #Inventory( ) in sql ? and how its work with store pro开发者_高级运维cedure ?

As you correctly assumed, it's a temporary table.

See a discussion here or here for some more info.

And they work just fine in stored procedures.

CREATE TABLE #Inventory ( InventoryID int PRIMARY KEY IDENTITY(1,1) , InventoryName varchar(100) ) GO