【场景】数据库知识，将字符串拆分成多行
【chatgpt】
【案例】
```sql
alter FUNCTION dbo.SplitString
(
@InputString NVARCHAR(MAX),
@Delimiter NVARCHAR(1)
)
RETURNS @OutputTable TABLE (id NVARCHAR(MAX))
AS
BEGIN
DECLARE @StartIndex INT, @EndIndex INT
SET @StartIndex = 1
SET @EndIndex = CHARINDEX(@Delimiter, @InputString)
WHILE @EndIndex > 0
BEGIN
INSERT INTO @OutputTable (id)
SELECT SUBSTRING(@InputString, @StartIndex, @EndIndex - @StartIndex)
SET @StartIndex = @EndIndex + 1
SET @EndIndex = CHARINDEX(@Delimiter, @InputString, @StartIndex)
END
INSERT INTO @OutputTable (id)
SELECT SUBSTRING(@InputString, @StartIndex, LEN(@InputString) - @StartIndex + 1)
RETURN
END
alter procedure pro_test @billnos varchar(max)
as
begin
declare @billnotable TABLE (id NVARCHAR(MAX))
insert into @billnotable
select * from dbo.SplitString(@billnos,',');
select FID,FBILLNO from T_PUR_POORDER bill
inner join @billnotable inputs on bill.FBILLNO = inputs.id
end
exec pro_test 'CGDD000026A,CGDD000030A,CGDD000096A'
```
【效果】传入按逗号分隔的字符串，能够将其转为表，进行联查
