Can anyone help me see what this code means? Thank you!

lwl115

DECLARE @ArticleId INT
SET @ArticleId = @@ IDENTITY
Ranch
INSERT INTO CrossArticleRole SELECT @ArticleID, intValue FROM dbo.csvToInt (@Roles)
INSERT INTO CrossArticleCategory SELECT @ArticleID, intValue FROM dbo.csvToInt (@Categories)

cv4bf5d65fd

DECLARE @ArticleId INT --- Define a variable of integer type
SET @ArticleId = @@ IDENTITY --- Set the variable to auto-increment column

--- Insert into the CrossArticleRole table, the record content is dbo.csvToInt (@Roles) The result content csvToInt This is a function

INSERT INTO CrossArticleRole SELECT @ArticleID, intValue FROM dbo.csvToInt (@Roles)


--- Insert into the CrossArticleCategory table, the record content is dbo.csvToInt (@Categories) result content csvToInt This is a function
INSERT INTO CrossArticleCategory SELECT @ArticleID, intValue FROM dbo.csvToInt (@Categories)

3972500

DECLARE @ArticleId INT --- Define a variable of integer type
SET @ArticleId = @@ IDENTITY --- Set the variable to auto-increment column
-------------------------
DECLARE @ArticleId INT
SET @ArticleId = @@ IDENTITY
select @ArticleId
How come the result is null?