1

what is

CREATE TABLE #Inventory( ) in sql ? and how its work with store procedure ?

Noname
  • 71
  • 1
  • 1
  • 6

2 Answers2

2

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.

Community
  • 1
  • 1
SWeko
  • 30,434
  • 10
  • 71
  • 106
-1

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

Robbie Tapping
  • 2,516
  • 1
  • 17
  • 18
  • This has absolutely no value as an answer to the question. Try to explain a little, or give some helpfull links to the answer/documentation that can help. – Adriaan Stander Feb 28 '11 at 11:54