create temp table

Question

Table name: tblTemp colimns iTeaQtyiTeaAmountiCoffeeQtyiCoffeAmountiAccid how can we create a temporary table in sql server 2005

Girish Sapariya · Answer

Hi Maneesh While creating table use '#' before the name of table. That will create your temporary table e.g Create Table #temp ( ID int Name varchar(20) ); Hope this will help Thanks

Abhay Shanker · Answer

CREATE TABLE #tblTemp( iTeaQty int  iTeaAmount decimal  iCoffeeQty decimal iCoffeAmount decimal iAccid int )

Jose Padro · Answer

Create table #tblTemp ( iTeaQty int iTeaAmount .....);