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