EXEC sp_configure 'show advanced option', '1'
RECONFIGURE
EXEC sp_configure 'Ad Hoc Distributed Queries',1
RECONFIGURE
select cast([应用编码] as varchar(3)) as id,cast([电话] as varchar(50) ) as tel ,cast([邮箱] as varchar(50) ) as mail into temp from
openrowset('MICROSOFT.JET.OLEDB.4.0','Excel 8.0;DATABASE=d:\aa.xls',sheet1$)
where len([电话])>0 and len([邮箱])> 0
declare @id varchar(3)
declare @tel varchar(50)
declare @mail varchar(50)
declare @str varchar(7000)
declare my_cursor cursor for select * from temp
OPEN my_cursor
FETCH NEXT FROM my_cursor INTO @id, @tel,@mail
set @str=''
WHILE @@FETCH_STATUS = 0
BEGIN
set @str = @str + 'case '+ @id + ':' + char(13) + char(10) + ' str="'+ @tel + '<br/>'+ @mail + '";' + char(13) + char(10) + ' break;' + char(13) + char(10)
FETCH NEXT FROM my_cursor INTO @id, @tel,@mail
end
CLOSE my_cursor
DEALLOCATE my_cursor
drop table temp
print @str
EXEC sp_configure 'Ad Hoc Distributed Queries',0
RECONFIGURE
EXEC sp_configure 'show advanced option', '0'
RECONFIGURE