create table #TB_QF(Area nvarchar(128),
DBname varchar(100),
[File] nvarchar(200),
File1 nvarchar(200),
Mo varchar(100),
Qfy varchar(100),
Service_id varchar(100),
Qfy_content varchar(400))
--select * from #TB_QF
declare @Area varchar(100)
declare @DBname varchar(100)
declare @File varchar(100)
declare @File1 varchar(100)
declare @Mo varchar(100)
declare @Qfy varchar(100)
declare @Svc_id varchar(100)
declare @Qfy_content varchar(400)declare my_cursor cursor for
select area,DBname,[file],File1,mo,qfy from #TB2
open my_cursor
fetch next from my_cursor into @Area,@DBname,@File,@File1,@Mo,@Qfy
while @@fetch_status=0
begin
insert into #TB_QF(Area,DBname,[File],File1,Mo,Qfy,Service_id,Qfy_content)
exec('
select Area='''+@Area+''',
DBname='''+@DBname+''',
[File]='''+@File+''',
File1='''+@File1+''',
Mo='''+@Mo+''',
Qfy='''+@Qfy+''',
Service_id=b.service_id,
Qfy_content=a.content
from (select content
from OPENROWSET(''MICROSOFT.JET.OLEDB.4.0'',''Text;HDR=YES;DATABASE='+@File1+''','+@Qfy+'#txt)) a,
test.dbo.service b
where charindex(b.service_id,a.content)<>0'
)
truncate table #TB_QFfetch next from my_cursor into @Area,@DBname,@File,@File1,@Mo,@Qfyendclose my_cursorDEALLOCATE my_cursor-----在运行这个游标时出现这样的错误:服务器: 消息 8501,级别 16,状态 3,行 2
服务器 'USER-53ACFA05BF' 上的 MSDTC 不可用。----谁知道这是什么错误呀!!
DBname varchar(100),
[File] nvarchar(200),
File1 nvarchar(200),
Mo varchar(100),
Qfy varchar(100),
Service_id varchar(100),
Qfy_content varchar(400))
--select * from #TB_QF
declare @Area varchar(100)
declare @DBname varchar(100)
declare @File varchar(100)
declare @File1 varchar(100)
declare @Mo varchar(100)
declare @Qfy varchar(100)
declare @Svc_id varchar(100)
declare @Qfy_content varchar(400)declare my_cursor cursor for
select area,DBname,[file],File1,mo,qfy from #TB2
open my_cursor
fetch next from my_cursor into @Area,@DBname,@File,@File1,@Mo,@Qfy
while @@fetch_status=0
begin
insert into #TB_QF(Area,DBname,[File],File1,Mo,Qfy,Service_id,Qfy_content)
exec('
select Area='''+@Area+''',
DBname='''+@DBname+''',
[File]='''+@File+''',
File1='''+@File1+''',
Mo='''+@Mo+''',
Qfy='''+@Qfy+''',
Service_id=b.service_id,
Qfy_content=a.content
from (select content
from OPENROWSET(''MICROSOFT.JET.OLEDB.4.0'',''Text;HDR=YES;DATABASE='+@File1+''','+@Qfy+'#txt)) a,
test.dbo.service b
where charindex(b.service_id,a.content)<>0'
)
truncate table #TB_QFfetch next from my_cursor into @Area,@DBname,@File,@File1,@Mo,@Qfyendclose my_cursorDEALLOCATE my_cursor-----在运行这个游标时出现这样的错误:服务器: 消息 8501,级别 16,状态 3,行 2
服务器 'USER-53ACFA05BF' 上的 MSDTC 不可用。----谁知道这是什么错误呀!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货