Microsoft sql server, управляющие конструкции

а я подемпингую:

1.
DECLARE @a integer
SET @a = 123235348

DECLARE @b varchar(32)
SET @b = cast(@a as varchar(32))

DECLARE @i integer, @j integer

SET @i = 0
WHILE @i < 10 BEGIN
SET @j = 0
WHILE @j < @i BEGIN
SET @b = REPLACE(@b, cast(@i as varchar(1))+cast(@j as varchar(1)), cast(@i as varchar(1))+'*')
SET @j = @j + 1
END
SET @i = @i + 1
END

SET @b = REPLACE(@b, '*', '')
print @b

2.
DECLARE @a varchar(256)
SET @a = 'ооо дана произвольная строка'

DECLARE @b TABLE (c varchar(256))
DECLARE @d integer

WHILE @a != '' BEGIN
SET @d = charindex(' ', @a)
IF @d = 0 BEGIN INSERT INTO @b VALUES (@a) SET @a = '' CONTINUE END
INSERT INTO @b VALUES (SUBSTRING(@a, 1, @d-1))
SET @a = rtrim(ltrim(SUBSTRING(@a, @d+1, 256)))
END

SELECT len(
ltrim(rtrim(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
lower(c),
'а', ''), 'я', ''), 'о', ''), 'ё', ''), 'у', ''),
'ю', ''), 'ы', ''), 'и', ''), 'э', ''), 'е', '')
))
)
FROM @b

правда, не знаю, правильно или нет ^_^