Splitte streng op

nix, der findes ikke en split i T-SQL.  Du kan bygge videre på nedenstående.

create procedure MySplitter(@s varchar(1000))
as
declare @s varchar(1000), @a int
While len(@s)>0 begin
  set @a=charindex(';',@s)
  exec myOwnSp substring(@s,1,@a-1))
  set @s = right(@s,len(@s)-@a)
end
go

Hver lige obs på, at ; er splittegnet og at strengen SKAL slutte med ; for at ovenstående virker.

Hov, pinlig kodefejl

create procedure MySplitter(@s varchar(1000))
as
declare @t varchar(1000), @a int
While len(@s)>0 begin
  set @a=charindex(';',@s)
  set @t=substring(@s,1,@a-1))
  exec myOwnSp @t
  set @s = right(@s,len(@s)-@a)
end
go

Super... 1000 tak for hjælpen trer!
Jeg fik tilpasset dit eksempel:

CREATE PROCEDURE MySplitter(@content VARCHAR(1000))
AS
DECLARE @ord VARCHAR(1000), @ordpos INT
SET @content = @content + '  '

WHILE LEN(@content) > 0
BEGIN
    -- Returns the starting position of the specified expression in a character string.
    SET @ordpos = CHARINDEX(' ', @content) -1
    -- Returns part of a character, binary, text, or image expression.
    SET @ord = SUBSTRING(@content, 1, @ordpos)
    -- Returns the part of a character string starting a specified number of integer_expression characters from the right.
    SET @content = RIGHT(@content, (LEN(@content) - @ordpos + 1))
    --
    PRINT @ord
END
GO

EXEC MySplitter @content='Dette er en test'