Click here to Skip to main content
12,952,215 members (62,435 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Recently i tried to create one temp table before dynamic sql and i compiled the SP.
when i tried to execute the SP it is giving the error like my temp table doen't exist
PROCEDURE [dbo].[Proc_test]
DECLARE @sqlstring NVARCHAR(4000)
select * into #test from xtable
SET @sqlstring='select * from #test'

now it is compiling fine but at the time of executing it is showing the error like
#test doesn't exist
Posted 2-Jan-13 2:59am
Updated 2-Jan-13 3:06am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

The scope of the temp table is limited to the dynamic query when its defined within the dynamic query. Alternate options are - you can use Global temporary table[^] or create the temp table outside your dynamic query. Take a look at the below link for more information[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,239
CHill60 3,490
Maciej Los 3,083
Jochen Arndt 1,975
ppolymorphe 1,880

Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 2 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100