DECLARE @zdanie VARCHAR(1000) = 'Ala ma kota   i psa';
DECLARE @separator CHAR(1) = ' ';
DECLARE @wyraz VARCHAR(1000);
DECLARE @i INT= 1;
DECLARE @len INT = LEN(@zdanie);
DECLARE  @TabelaWyrazow TABLE
(
        wyraz VARCHAR(1000)
)
WHILE(1>0)
BEGIN
        IF(CHARINDEX(@separator, @zdanie) != 0 AND CHARINDEX(@separator, @zdanie) != 1)
                BEGIN
                        INSERT INTO @TabelaWyrazow
                        SELECT LEFT(@zdanie, CHARINDEX(@separator, @zdanie));
                        SET @zdanie = RIGHT(@zdanie, @len - CHARINDEX(@separator, @zdanie));
                        SET @len = LEN(@zdanie);
                        SET @i = @i + 1;
                END
        ELSE IF(CHARINDEX(@separator, @zdanie) = 1)
                BEGIN
                        SET @zdanie = RIGHT(@zdanie, @len - CHARINDEX(@separator, @zdanie));
                        SET @len = LEN(@zdanie);
                        SET @i = @i + 1;
                END
        ELSE IF(CHARINDEX(@separator, @zdanie) = 0)
                BREAK;
END
INSERT INTO @TabelaWyrazow
SELECT @zdanie;
SELECT * FROM @TabelaWyrazow;