我是大傻子333*242*222 生活是是是是
create proc ccc
as
declare @cur cursor,
@pp_length decimal(20,8),
@pp_width decimal(20,8),
@pp_height decimal(20,8),
@length nvarchar(30),
@width nvarchar(30),
@height nvarchar(30),
@item nvarchar(30),
@description nvarchar(100)
create table @a--创建虚拟表
(
length nvarchar(30),
width nvarchar(30),
height nvarchar(30),
length1 decimal(20,8),
width1 decimal(20,8),
height1 decimal(20,8),
item nvarchar(30),
description nvarchar(100)
)
set @cur = cursor static for
select pp_length,pp_width,pp_height,description,item from 表名
open @cur
while(1=1)
begin
fetch next from @cur into @pp_length,@pp_width,@pp_height,@description,@item
if(@@FETCH_STATUS <> 0)
break
set @length = right(left(@description,charindex('*',@description)-1),3)
set @width = left(Stuff(@description,1,charindex('*',@description),''),charindex('*',stuff(@description,1,charindex('*',@description),''))-1)
set @height = SUBSTRING( Stuff(@description,1,charindex('*',@description),''),5,3)
if( @length <> ltrim(rtrim(cast(cast(@pp_length as int) as nvarchar(30)))) or
@width <> ltrim(rtrim(cast(cast(@pp_width as int) as nvarchar(30)))) or
@height <> ltrim(rtrim(cast(cast(@pp_height as int) as nvarchar(30)))))
insert into @a values (@length,@width,@height,@pp_length,@pp_width,@pp_height,@item,@description)
end
close @cur
deallocate @cur
select * from @a