Information générale
Titre:
Temp tables with ado
Hi I am trying to create a temporary table via ado with the following statement, which I pass to the execute method
create table #temp1(age int)
The temp table is being created.
I am then trying to select from this temp table, with a simple select statement
select * from #temp1
I then get an error that the table can not be found.
So I tried to qualify the table name with the database name
select * from tempdb..#temp1
But this does not work either.
Doe anyone have any idea how to do this
Hope you can help
Regards
Steven
Suivant
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