如何将DBCC INDEXDEFRAG 执行的结果插入到表中?

比如:
use northwind
go
DBCC INDEXDEFRAG (Northwind, Orders, PK_Orders)
我相将它执行的结果插入到一个表中,请问何种方法可以实现?
谢谢大家。
---------------------------------------------------------------

-- 获取数据
DECLARE @err int,@src varchar(255),@desc varchar(255)
DECLARE @obj int,@str varchar(1000)
-- 使用 Windows 身份登录
SET @str='Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source='

-- 使用 SQL Server 身份登录则用此字符串,注意设置用户名和密码
-- SET @str='Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=master;Data Source=;User ID=sa;Password='

-- 创建对象
EXEC @err=sp_oacreate 'adodb.recordset',@obj OUT
IF @err<>0 GOTO lberr

-- 获取需要的数据
EXEC @err=sp_oamethod @obj,'open',null,'DBCC INDEXDEFRAG (Northwind, Orders, CustomersOrders)',@str
IF @err<>0 GOTO lberr

CREATE TABLE #(Column0 int,Column1 int,Column2 int)
INSERT # EXEC @err=sp_oamethod @obj,'getrows'
IF @err<>0 GOTO lberr

EXEC @err=sp_oadestroy @obj
RETURN

lberr:
EXEC sp_oageterrorinfo 0,@src OUT,@desc OUT
SELECT CAST(@err as varbinary(4)) as 错误号,
@src as 错误源,@desc as 错误描述
GO

-- 显示结果
SELECT * FROM #
DROP TABLE #

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus