fnMakeIDsTableFromString
Return
Return Type |
---|
table |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@IDString | nvarchar(max) | IN | |
@Delim | nvarchar(8) | IN |
Definition
Copy
CREATE function [dbo].[fnMakeIDsTableFromString](@IDString nvarchar(max), @Delim nvarchar(8))
returns @IDTable TABLE(id integer)
as begin
declare @intPos INTEGER
set @intPos = charindex(@Delim,@IDString)
while @intPos > 0
begin
insert into @IDTable select left(@IDString,@intPos-1)
set @IDString = substring(@IDString,@intPos+1,LEN(@IDString)-@intPos)
set @intPos = charindex(@Delim,@IDString)
end
if (len(@IDString) > 0)
insert into @IDTable select @IDString
return
end