18 lines
462 B
Plaintext
18 lines
462 B
Plaintext
|
CREATE PROCEDURE [dbo].[sp_SensorTestHistoryDelete]
|
||
|
|
@SensorTestHistoryId BIGINT = NULL,
|
||
|
|
@SensorId INT = NULL
|
||
|
|
AS
|
||
|
|
BEGIN
|
||
|
|
IF @SensorId IS NOT NULL
|
||
|
|
BEGIN
|
||
|
|
DELETE FROM [dbo].[SensorTestHistory] WHERE [SensorId]=@SensorId
|
||
|
|
END
|
||
|
|
ELSE IF @SensorTestHistoryId IS NOT NULL
|
||
|
|
BEGIN
|
||
|
|
DELETE FROM [dbo].[SensorTestHistory] WHERE [SensorTestHistoryId]=@SensorTestHistoryId
|
||
|
|
END
|
||
|
|
ELSE
|
||
|
|
BEGIN
|
||
|
|
DELETE FROM [dbo].[SensorTestHistory]
|
||
|
|
END
|
||
|
|
END
|