存储过程--插入--查询

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_time<= @End_time
GO