salut, revin cu o intrebare
de ce daca rulez:
set @strSQL='select * from TempTable order by startTime'
exec sp_executesql @strSQL
imi afiseaza tot ce contine tabela respectiva
iar daca vreau sa rulez astfel:
set @strSQL='select * from '+@gTemp_table+' order by startTime'
exec sp_executesql @strSQL
nu-mi afiseaza nimic dar imi spune
The command(s) completed successfully.
cum pot afisa ce contine respectiva tabela daca ea este o variabila locala
multumesc