--exec getRecord @sType='search',@Cfilename='20200511182808_1439_liuzhou01'
-- exec getRecord '20200511182901_1439_liuzhou01', '1439', 'liuzhou01', 'E:\\WANGBAO\\Ecovacs_Wangbao_Data\\DC006_data\\10.90.26.157\\2020-05-11', 'http://10.90.26.209:8005/Ecovacs_Wangbao_Data/DC006_data/10.90.26.157/2020-05-11/20200511182901_1439_liuzhou01.flv', 'rtmp://222.92.255.146/DC001Ser06/20200511182901_1439_liuzhou01.flv', '2020-05-19 22:23:08', '2020-05-11 18:31:39'
alter proc getRecord(
@Cfilename varchar(100)='',
@Crebot_code varchar(50)='',
@Crecode_name nvarchar(50)='',
@Cdirpath nvarchar(128)='',
@Cdown_urls nvarchar(256)='',
@Crmtp_url nvarchar(256)='',
@Ccreate_time datetime='',
@Cmodify_time datetime='',
@Ccount int ='1',
@Cflag bit=0
)
as
begin
begin
declare @iCount int
select @iCount= count(*) from Trecode
where Cfilename=@Cfilename
if @iCount>0
begin
update Trecode set Cdirpath=@Cdirpath,Cdown_urls=@Cdown_urls,Crmtp_url=@Crmtp_url,Ccreate_time=@Ccreate_time,Cmodify_time=@Cmodify_time,Ccount=@Ccount+1,Cflag=@Cflag
where Cfilename=@Cfilename
end
else
begin
insert into TRecode (Cfilename,Crebot_code,Crecode_name,Cdirpath,Cdown_urls,Crmtp_url,Ccreate_time,Cmodify_time) values(@Cfilename,@Crebot_code,@Crecode_name,@Cdirpath,@Cdown_urls,@Crmtp_url,@Ccreate_time,@Cmodify_time)
end
end
end
存储过程,判断插入还是修改
最新推荐文章于 2021-01-19 07:22:23 发布