colimns" iTeaQty,iTeaAmount,iCoffeeQty,iCoffeAmount,iAccid
how can we create a temporary table in sql server 2005
create temp table
Table name: tblTemp
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Girish SapariyaPosted Dec 2, 2013, 5:09 AM
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 ShankerPosted Dec 1, 2013, 10:34 PM
CREATE TABLE #tblTemp(
iTeaQty int,
iTeaAmount decimal ,
iCoffeeQty decimal,
iCoffeAmount decimal,
iAccid int
)
Jose PadroPosted Dec 1, 2013, 1:03 PM