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
Real 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.)
Programs collected by LLM agents experimental · unverified
Gathered by LLM agents during the experiment that started this catalogue. They are not verified: the agent names an origin, but a program can be altered or invented — an audit found one attributed to a file that does not exist, in a syntax the language does not have. Prefer the programs archived by Software Heritage above. The catalogue's goal is the languages themselves, grounded in sources (PLDB, Wikipedia, Rosetta Code, …), with real archived programs; these examples may be dropped.
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)
);
GO