sql中使用游标

 

declare   @ss   varchar ( 300 )
declare   @csr   CURSOR  
set   @csr = cursor   for
select  statpartno  from  catalog  where  flag = 2

open   @csr  
fetch   next   from   @csr
-- print @@FETCH_STATUS
while   @@FETCH_STATUS = 0
begin
fetch   next   from   @csr   into   @ss
print   @ss + ' | '

-- =====================================
declare   @a   VARCHAR ( 8000 )
set   @a = @ss

DECLARE   @SubStr   VARCHAR ( 8000 )
         set   @a = rtrim ( @a )
    
     SET   @SubStr   =   LEFT ( @a , CHARINDEX ( ' - ' , @a , 0 ) - 1 )  
     SET   @a   =   RIGHT ( @a , Len ( @a ) - CHARINDEX ( ' - ' , @a , 0 )) 
     SET   @SubStr   =   LEFT ( @a , CHARINDEX ( ' - ' , @a , 0 ) - 1 )  
     SET   @a   =   RIGHT ( @a , Len ( @a ) - CHARINDEX ( ' - ' , @a , 0 ) - 1 ) 
     Set   @subStr = right ( ' 000000 ' + @a , 6 )    


print   @SubStr
-- =====================================

end  
close    @csr
deallocate   @csr

-- dbo.getDistance 'FTM-8020C-S'