DP44/DataPRO/Modules/Database/DatabaseMigrationScripts/.svn/pristine/cd/cd5b93ad62f57c744382e94dcf3ba563d494403d.svn-base

<EFBFBD><EFBFBD>ALTER PROCEDURE [dbo].[sp_SoftwareFiltersInsert]
	@ISOCode			CHAR (1),
	@Description		NVARCHAR (255),
	@Frequency			FLOAT,
	@LastModified		DATETIME,
	@LastModifiedBy		NVARCHAR (255),
	@errorNumber		INT OUTPUT,
	@IsDefault			BIT ,
	@errorMessage		NVARCHAR (255) OUTPUT,
	@new_id				INT OUTPUT
AS
BEGIN
	SET NOCOUNT ON;
	SET @errorNumber=0
	SET @errorMessage=''
	INSERT INTO [dbo].[SoftwareFilters] ([ISOCode],[Description],[Frequency],[LastModified],[LastModifiedBy],[IsDefault]) VALUES (@ISOCode, @Description, @Frequency, @LastModified, @LastModifiedBy, @IsDefault)

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