25 lines
1.4 KiB
Plaintext
25 lines
1.4 KiB
Plaintext
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 |