CREATE PROCEDURE [INSERT_ALARM]
(
@alarm_time char(14),
@channel_name char(6),
@server_ip char(32),
@alarm_actor char(32),
@alarm_type char(6),
@alarm_stage char(32),
@alarm_action char(128),
@alarm_bmppath char(128)
)
AS
INSERT INTO alarm_log
(
[alarm_time ],
[channel_name],
[server_ip],
[alarm_actor],
[alarm_type],
[alarm_stage],
[alarm_action],
[alarm_bmppath]
)
VALUES
(
@alarm_time,
@channel_name,
@server_ip,
@alarm_actor,
@alarm_type,
@alarm_stage,
@alarm_action,
@alarm_bmppath
)
GO
多参数查询
CREATE PROCEDURE SELECT_ALL
@channel_name varchar(6),
@server_ip varchar(32),
@Begin_time varchar(15)= '1900-01-01',
@End_time varchar(15) = '2900-01-01'
AS
IF @Begin_time is NULL
set @Begin_time = '1900-01-01'
IF @End_time is NULL
set @End_time = '2030-01-01'
SELECT *
FROM alarm_log WHERE
channel_name = isnull(nullif( @channel_name,''),channel_name) AND
server_IP = isnull(nullif( @server_ip,''),server_IP) AND
alarm_time >= @Begin_time AND alarm_timeGO