作业帮 > 综合 > 作业

英语翻译文件名是UserConfig.sql内容是:GO--delete old recorddelete from s

来源:学生作业帮 编辑:搜搜考试网作业帮 分类:综合作业 时间:2024/06/11 01:56:39
英语翻译
文件名是UserConfig.sql
内容是:
GO
--delete old record
delete from sysparam where p_name = 'Authercase'
delete from sysparam where p_name = 'UserCFG_CRCCode'
delete from sysparam where p_name = 'UserCFG_ICCard_Pwd'
GO
---- From Date:2007-12-08 to Date:2017-12-08
---- dg1x0F]:y]J]F]M^MmK]VJGCdfk\79wwl]Ogvchq
--set valid
IF NOT EXISTS(select * from sysparam where p_name = 'Authercase')
INSERT INTO sysparam
( p_name,p_type,p_string,p_int,p_float,p_date,note,Category,p_sort )
VALUES ('authercase','C','dg1x0F]:y]J]F]M^MmK]VJGCdfk\79wwl]Ogvchq',39424,43077,NULL,'AKPUB1E677748B8FC9526AAOH','system','Private')
GO
INSERT INTO sysparam
( p_name,p_type,p_string,p_int,p_float,p_date,note,Category,p_sort )
VALUES ('UserCFG_CRCCode','C','Y',52853,24612,getdate(),'UserCFG_CRCCode','user','Private')
GO
INSERT INTO sysparam
( p_name,p_type,p_string,p_int,p_float,p_date,note,Category,p_sort )
VALUES ('UserCFG_ICCard_Pwd','C','FFFFFF',0 ,18008,getdate(),'EA5318','user','Private')
GO
我想知道 他是什么含义,有什么用途.
绝对给追分,
能不能在详细一些,加什么样的记录等.
英语翻译文件名是UserConfig.sql内容是:GO--delete old recorddelete from s
删除旧记录.
IF NOT EXISTS(select * from sysparam where p_name = 'Authercase') 如果不存在记录就添加.
再添加两条