Transact-SQL
1 program
Added 2025-11-02T09:50:32Z
Model: google/gemini-2.5-proTemp: 0.4
Evidence
Report issue
View issues
Aliases: T-SQL
Provenance: commit 6704b0004b · authored 2025-11-02T10:50:32+01:00 · model google/gemini-2.5-pro
Sources mentioning this language
5 sources · pl_id:
pl/transact-sqlRelated languages
LLM-contributed programs
T-SQL String Splitting Function (CTE version)
Provenance: commit 6704b0004b · authored 2025-11-02T10:50:32+01:00 · model google/gemini-2.5-pro · Temp 0.4
CREATE FUNCTION dbo.SplitStrings_CTE
(
@List NVARCHAR(MAX),
@Delimiter NVARCHAR(255)
)
RETURNS TABLE
WITH SCHEMABINDING
AS
RETURN
(
WITH n(n) AS
(
SELECT 1 UNION ALL SELECT n+1
FROM n WHERE n < 4000
)
SELECT
Item = SUBSTRING(@List, n, CHARINDEX(@Delimiter, @List + @Delimiter, n) - n)
FROM
(
SELECT n = 1
UNION ALL
SELECT n + 1
FROM n
WHERE n < LEN(@List) AND SUBSTRING(@List, n, 1) = @Delimiter
) AS a
OPTION (MAXRECURSION 0)
);
GOReal programs from Software Heritage
No SWH evidence indexed yet for this language. (Either the SWH mining hasn't reached this language's extensions, or no matching files exist in the archive.)