CREATE TABLE [dbo].[AlarmActivate](
    [ID] [NCHAR](10) NULL,
    [St_1] [INT] NULL,
    [St_2] [INT] NULL,
    [St_3] [INT] NULL
        [St_4] [INT] NULL
) ON [PRIMARY]
 
INSERT INTO FromPLC (ID, St_1, St_1, St_1) VALUES ('PLC_Data',   3,0,3,3);
INSERT INTO FromPLC (ID, St_1, St_1, St_1) VALUES ('PC_Data',    1,0,0,1);
INSERT INTO FromPLC (ID, St_1, St_1, St_1) VALUES ('Result',    NULL,NULL,NULL,NULL);

ALTER FUNCTION [dbo].[On_Off_Alarm]
(
    @From_Device tinyint,
    @Off_From_Station tinyint
)
RETURNS tinyint
AS
BEGIN
    RETURN
        CASE 
            WHEN @From_Device = 3 AND @Off_From_Station = 0 THEN 0
            WHEN @From_Device = 3 AND @Off_From_Station = 1 THEN 3
 
            ELSE 1
        END 
END

INSERT INTO FromPLC (ID, St_1, St_1, St_1) VALUES ('PLC_Data',   3,0,3,3);
INSERT INTO FromPLC (ID, St_1, St_1, St_1) VALUES ('PC_Data',    1,0,0,1);
INSERT INTO FromPLC (ID, St_1, St_1, St_1) VALUES ('Result',     3,0,0,3);