<commit_before>﻿

CREATE PROCEDURE [dbo].[CreateNotification]
	@UserId INT, 
	@DateTime DATETIME ,
	@ForecFormat BIT = 0,
	@TemplateId VARCHAR(20),
	@Data NVARCHAR(MAX),
	@MessageFormat TINYINT
as
BEGIN
	INSERT INTO [dbo].[Notification]
		(UserId, DateTime, ForecFormat, TemplateId,Data,MessageFormat)
	VALUES
		(@UserId,@DateTime, @ForecFormat, @TemplateId, @Data, @MessageFormat)

	SELECT Id = SCOPE_IDENTITY()
END<commit_msg>Missed adding of output parameter for Id from Creating a notification entry<commit_after>﻿

CREATE PROCEDURE [dbo].[CreateNotification]
	@id INT OUTPUT,
	@UserId INT, 
	@DateTime DATETIME ,
	@ForecFormat BIT = 0,
	@TemplateId VARCHAR(20),
	@Data NVARCHAR(MAX),
	@MessageFormat TINYINT
as
BEGIN
	INSERT INTO [dbo].[Notification]
		(UserId, DateTime, ForecFormat, TemplateId,Data,MessageFormat)
	VALUES
		(@UserId,@DateTime, @ForecFormat, @TemplateId, @Data, @MessageFormat)

	SELECT @Id = SCOPE_IDENTITY()
END
{'fraction_non_alphanumeric': 0.11645299145299146, 'fraction_numerical': 0.00641025641025641, 'mean_word_length': 6.3203125, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3114758', 'n_tokens_mistral': 347, 'n_tokens_neox': 323, 'n_words': 85}