sqlserver备份存储过程

创建备份用的表

if OBJECT_ID('bakuser_comments') is null

create table bakuser_comments(id bigint,name varchar(500),colid int,text varchar(max),objtime datetime,objexplain varchar(255))

 

执行备份，根据备份名称确定是否备份过

if not exists(select 1 from bakuser_comments where objexplain ='升级备份')

insert into bakuser_comments

(id,name,colid,text,objtime,objexplain)

select id,OBJECT_NAME(id),colid,text,getdate(),'升级备份'

from syscomments

where id=OBJECT_ID('存储过程名称')