国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

前一段時(shí)間由于碰到兩個(gè)數(shù)據(jù)庫(kù)的數(shù)據(jù)轉(zhuǎn)移!

所以加深了對(duì)SQL的一個(gè)字符操作函數(shù)的了解,NTEXT,TEXT,IMAGE這些數(shù)據(jù)類(lèi)型都不能使用一些通用的操作函數(shù)如left,right,trim 等

由于我要轉(zhuǎn)移的數(shù)據(jù)的表有的使用了ntext的數(shù)據(jù)

在這個(gè)字段里有一些數(shù)據(jù)要更新!

所以用腳本語(yǔ)言asp來(lái)做一個(gè)中轉(zhuǎn)!
我想說(shuō)的是有這種情況最好要用腳本做一個(gè)中轉(zhuǎn)


SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROC SORT
@NEW VARCHAR(8),
@OLD varchar(8)
as
 
declare my_cursor cursor  dynamic /*scroll表示可隨意移動(dòng)游標(biāo)指針（否則只能向前），dynamic表示可以讀寫(xiě)游標(biāo)（否則游標(biāo)只讀）*/
for
 select ecomsql.dbo.comwenzhanglei.id,ecomsql.dbo.comwenzhanglei.lei,ecomsql.dbo.comwenzhanglei.connect from ecomsql.dbo.comwenzhanglei where ecomsql.dbo.comwenzhanglei.comid=@new
open my_cursor
declare @name char(100),@tempid int,@conn int

fetch next from my_cursor into @tempid,@name,@conn
while(@@fetch_status=0)
  begin
 declare @data varchar(10)
 set @data=(select ecom.dbo.comwenzhanglei.id  from ecom.dbo.comwenzhanglei where ecom.dbo.comwenzhanglei.comid=@old and ecom.dbo.comwenzhanglei.lei=@name)
 if @data<>‘‘
   begin
    update ecomsql.dbo.comwenzhang set ecomsql.dbo.comwenzhang.lanid=@tempid where ecomsql.dbo.comwenzhang.comid=@new and ecomsql.dbo.comwenzhang.lanid=@data
   end
 if @conn<>0
   begin
  declare @tname varchar(20),@tid int
  set @tname=(select ecom.dbo.comwenzhanglei.lei from ecom.dbo.comwenzhanglei where ecom.dbo.comwenzhanglei.id=@conn and ecom.dbo.comwenzhanglei.comid=@old)
  set @tid=(select ecomsql.dbo.comwenzhanglei.id from ecomsql.dbo.comwenzhanglei where ecomsql.dbo.comwenzhanglei.lei=@tname and ecomsql.dbo.comwenzhanglei.comid=@new)
  update ecomsql.dbo.comwenzhanglei set ecomsql.dbo.comwenzhanglei.connect=@tid where ecomsql.dbo.comwenzhanglei.id=@tempid and ecomsql.dbo.comwenzhanglei.comid=@new
   end

    fetch next from my_cursor into @tempid,@name,@conn
  end
--fetch first from my_cursor into @name
close my_cursor
deallocate my_cursor

 

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

 

本站僅提供存儲(chǔ)服務(wù)，所有內(nèi)容均由用戶(hù)發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請(qǐng)點(diǎn)擊舉報(bào)。