ODBC connection Query shows no result
Does anyone know why this sql query doesn't return values? My excel version is 2007.
Thanks in advance.
Does anyone know why this sql query doesn't return values? My excel version is 2007.
Thanks in advance.
Code:
if object_id( 'TEMPDB..#TMPDOC') is not null
begin
drop table #TMPDOC
end
create table #TMPDOC (Code varchar(5) NOT NULL)
insert into #TMPDOC (code) VALUES
('AAAAA'),
('BBBBB'),
('CCCCC'),
('DDDDD'),
('EEEEE')
select * from #TMPDOC
if object_id( 'TEMPDB..#TMPDOC') is not null
begin
drop table #TMPDOC
end