一個導資料的遊標代碼

declare @GID varchar(36)
declare @Column_ID varchar(36)
declare @Column_Name varchar(36)
declare @Parent_ID    varchar(36)
declare @Fathers_ID varchar(36)
declare @Three    varchar(36)
declare @Main varchar(360)
DECLARE @cmd sysname, @var sysname
declare @int int
declare democursor cursor

for
select Gid,three,main,Column_ID,Parent_ID,fathers_ID,Column_Name from (select rtrim(ltrim(replace(substring(right(cast([主營產品或服務] as varchar(1200)),len(cast([主營產品或服務] as varchar(1200)))- charindex(';',cast([主營產品或服務] as varchar(1200)))),charindex(';',right(cast([主營產品或服務] as varchar(1200)),len(cast([主營產品或服務] as varchar(1200)))- charindex(';',cast([主營產品或服務] as varchar(1200)))))+1,charindex(';',right(cast([主營產品或服務] as varchar(1200)),len(cast([主營產品或服務] as varchar(1200)))- charindex(';',cast([主營產品或服務] as varchar(1200)))),charindex(';',right(cast([主營產品或服務] as varchar(1200)),len(cast([主營產品或服務] as varchar(1200)))- charindex(';',cast([主營產品或服務] as varchar(1200))))))),';',''))) three,[主營產品或服務] main,Gid from companys where Fid is null) tab ,V_sort bbb where tab.three like '%'+bbb.Column_Name+'%' and bbb.Column_Name<>'其他'
print '--start'
open democursor
fetch next from democursor into @GID,@Three,@Main,@Column_ID,@Parent_ID,@Fathers_ID,@Column_Name

while @@FETCH_STATUS=0

begin

print 'update companys set Fid='+isnull(@Fathers_ID,'')+',Sid='+isnull(@Parent_ID,'')+',Tid='+isnull(@Column_ID,'')+' where Gid='+isnull(@GID,'0')+'--'+isnull(@Main,'')+isnull(@Column_Name,'')
--insert into regulation(newone,newtwo,newthree,oldone,oldtwo) values(@Column_ID,@Parent_ID,@Fathers_ID,@bs_id,@ss_id)

fetch next from democursor into @GID,@Three,@Main,@Column_ID,@Parent_ID,@Fathers_ID,@Column_Name

end
print '--end'
close democursor
deallocate   democursor

 

 

一個到資料的遊標代碼