temp tables not working - Support Queries - myLittleTools Community Forum

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » temp tables not working

temp tables not working

Options · View

Previous Topic · Next Topic

devangp007

Posted: Thursday, June 14, 2007 3:07:29 PM

Rank: Member
Groups: Member

Joined: 6/11/2007
Posts: 12
Points: 9
Location: Kalamazoo,MI-USA

I get an error when i execute below query in query editor(error: #temp does not exist)

select * into #temp from tab1

select top 2 * from #temp

elian

Posted: Thursday, June 14, 2007 4:03:27 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

try

Code:

select * into #temp from company
go
select top 2 * from #temp
go

It works.

Users browsing this topic

Guest

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » temp tables not working

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.