1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
--捷信达服务器更换或IP更换需要修改的地方

exec up_rpt业务员销售明细表_all  @发生开始日期 = '2019-01-01', @发生结束日期 = '2019-10-01'


SELECT * FROM [dbo].[gsSyspara] WHERE CName like '%数据库连接参数'
UPDATE   [dbo].[gsSyspara]  set value = 'server=10.0.106.100;database=hmswq;uid=landv;pwd=fuck' WHERE CName ='温泉数据库连接参数'

SELECT * FROM [dbo].[cysyspara] WHERE v_para like '%服务器' AND v_value = '192.168.17.2'
UPDATE [dbo].[cysyspara] set v_value ='10.0.106.100' WHERE v_para like '%服务器' AND v_value = '192.168.17.2'


SELECT * FROM [dbo].[snSysPara] WHERE v_ParaName like '%服务器%' AND v_value = '192.168.17.2'
UPDATE [dbo].[snSysPara] set v_value ='10.0.106.100' WHERE v_ParaName like '%服务器%' AND v_value = '192.168.17.2'

SELECT dbo.uf_getEvn('snDataBaseName')

捷信达日志删除时间修改

账户：SzJxd

密码：7269

系统参数》修改日志保留天数，99999999天就好。