DP44/DataPRO/Modules/Database/DatabaseMigrationScripts/.svn/pristine/d7/d7b943b1d5013778cf0cbc41e0e4f8e9b1cbd088.svn-base

<EFBFBD><EFBFBD>ALTER PROCEDURE [dbo].[sp_SoftwareFiltersUpdate]
	@Id					INT,
	@ISOCode			CHAR (1),
	@Description		NVARCHAR (255),
	@Frequency			FLOAT,
	@LastModified		DATETIME,
	@LastModifiedBy		NVARCHAR (255),
    @IsDefault			BIT ,
	@errorNumber		INT OUTPUT,
	@errorMessage		NVARCHAR (255) OUTPUT

AS
BEGIN
	SET NOCOUNT ON;
	SET @errorNumber=0
	SET @errorMessage=''
	
	UPDATE [dbo].[SoftwareFilters] SET [ISOCode]=@ISOCode, [Description]=@Description, [Frequency]=@Frequency, [LastModified]=@LastModified, [LastModifiedBy]=@LastModifiedBy, [IsDefault]=@IsDefault WHERE [Id]=@Id

	if(@@error != 0)
	begin
		set @errorNumber = error_number()
		set @errorMessage = error_message()
	end
END