declare @ref varchar(100) set @ref='Progress32' declare @i int,j int set @i=cast(left(right(@ref,2),1) as int) set @j=cast(right(@ref,1) as int) while (i <=@i) begin while(j <=@j) begin end end
DECLARE @STR VARCHAR(20) DECLARE @I INT, @J INTSET @STR='Progress32' SET @J=RIGHT(@STR,1) SET @I=SUBSTRING(@STR,LEN(@STR)-1,1)SELECT @I AS I,@J AS J
while (i <=left(right('Progress32',2),1)) begin while(j <=right('Progress32',2)) begin end end
declare @str varchar(30) declare @i int declare @j int select @str=right('Progress32',2) select @i=cast(substring(@str,1,1) as int) select @j=cast(substring(@str,2,1) as int) while @i<=3 Begin while @j<=2 begin end End
DECLARE @A INT DECLARE @B INT SELECT @A=RIGHT(RTRIM('PROGRESS32'),1) SELECT @B=LEFT(RIGHT(RTRIM('PROGRESS32'),2),1) WHILE(I<@B) BEGIN WHILE(J<@A) BEGIN END END
declare @ref varchar(100) set @ref='Progress32' declare @i int,j int set @i=cast(right(@ref,2) as int)/10 set @j=cast(right(@ref,1) as int) while (i <=@i) begin while(j <=@j) begin end end
select right('Progress32',2)
32
set @ref='Progress32'
declare @i int,j int
set @i=cast(left(right(@ref,2),1) as int)
set @j=cast(right(@ref,1) as int)
while (i <=@i)
begin
while(j <=@j)
begin
end end
DECLARE @I INT, @J INTSET @STR='Progress32'
SET @J=RIGHT(@STR,1)
SET @I=SUBSTRING(@STR,LEN(@STR)-1,1)SELECT @I AS I,@J AS J
begin
while(j <=right('Progress32',2))
begin
end end
declare @str varchar(30)
declare @i int
declare @j int
select @str=right('Progress32',2)
select @i=cast(substring(@str,1,1) as int)
select @j=cast(substring(@str,2,1) as int)
while @i<=3
Begin
while @j<=2
begin
end
End
DECLARE @B INT
SELECT @A=RIGHT(RTRIM('PROGRESS32'),1)
SELECT @B=LEFT(RIGHT(RTRIM('PROGRESS32'),2),1)
WHILE(I<@B)
BEGIN
WHILE(J<@A)
BEGIN END
END
declare @ref varchar(100)
set @ref='Progress32'
declare @i int,j int
set @i=cast(right(@ref,2) as int)/10
set @j=cast(right(@ref,1) as int)
while (i <=@i)
begin
while(j <=@j)
begin
end end