DP44/DataPRO_sql/dbo.Alter_sp_GroupsInsert.sql

<EFBFBD><EFBFBD>USE [DataPro]
GO
/****** Object:  StoredProcedure [dbo].[sp_GroupsInsert]    Script Date: 22/03/2019 15:37:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[sp_GroupsInsert]
	@SerialNumber       NVARCHAR (255),
	@Picture			NVARCHAR (255) = NULL,
	@DisplayName		NVARCHAR (255),
	@Embedded			BIT,
	@Description		NVARCHAR (255),
	@LastModified		DATETIME,
	@LastModifiedBy		NVARCHAR (255),
	@StaticGroupId		int = NULL,
	@errorNumber		int OUTPUT,
	@errorMessage		NVARCHAR (255) OUTPUT,
	@new_id				int OUTPUT
AS
BEGIN
	SET NOCOUNT ON;
	SET @errorNumber=0
	SET @errorMessage=''
	INSERT INTO Groups (SerialNumber, [Picture], DisplayName, [Description], Embedded,  LastModified,  LastModifiedBy,  StaticGroupId) 
			   VALUES (@SerialNumber, @Picture, @DisplayName, @Description, @Embedded, @LastModified, @LastModifiedBy, @StaticGroupId)

	SET @new_id = scope_identity();
	IF(@@error != 0)
	BEGIN
		SET @errorNumber = error_number()
		SET @errorMessage = error_message()
	END
END