Information générale
Forum:
Microsoft SQL Server
Why you call your execute the sql is executed in another batch. This means that your temp table is local to that batch, not the one the called the exec function. To get around this you need to prefix your table with 2 pound signs (##). That will make the temp table global.
>Hello everyone,
>I am trying to create a temp table and then insert some records in there:
>
>DECLARE @StrCreate varChar(500)
>SET @StrCreate = 'CREATE TABLE #curReport (ID Int, F1, F2...)' -- String,actually gets build for crosstab report
>EXECUTE(@StrCreate)
>SELECT * FROM #curReport
>
>It does not see #curReport after EXECUTE.
>If there any way around this.
>Please help.
>
>Thanks in advance..
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement