名站网址导航为大家提供关于数据库教程相关的教程网站知识。

解析SQLServer2005的Top功能Ii0aichat_企业网址导航_网址分类目录_企业黄页网址提交查询专业网站！

复制具体相关代码 具体相关代码如下:,set nocount on use tempdb go if (object_id ('tb' ) is not null ) drop table tb go create table tb (iIi0aichat_企业网址导航_网址分类目录_企业黄页网址提交查询专业网站！

复制具体相关代码 具体相关代码如下:Ii0aichat_企业网址导航_网址分类目录_企业黄页网址提交查询专业网站！

use tempdb
go
if (object_id ('udf_getExcelTableNames' ) is not null )
drop function dbo .udf_getExcelTableNames
go
create function udf_getExcelTableNames (@filename varchar (1000 ))
returns @t table (id int , name varchar (255 ))
as
begin
declare
@error int , @obj int , @c int , @sheetname varchar (255 ) , @sheetstring varchar (255 )

exec @error = sp_oacreate 'Excel.Application' , @obj out
exec @error = sp_oamethod @obj , 'Workbooks.Open' , @c out , @filename
exec @error = sp_oagetproperty @obj , 'ActiveWorkbook.Sheets.Count' , @c out
while (@c > 0 )
begin
set @sheetstring = 'ActiveWorkbook.Sheets(' ltrim (@c ) ').Name'
exec @error = sp_oagetproperty @obj , @sheetstring , @sheetname out
insert into @t select @c , @sheetname
set @c = @c - 1
end
exec @error = sp_oadestroy @obj
return
end
go
select * from dbo .udf_getExcelTableNames ('e:/aa.xls' )
/*--测试结果
3 Sheet3
2 Sheet2
1 Sheet1
*/
Ii0aichat_企业网址导航_网址分类目录_企业黄页网址提交查询专业网站！