捷信达服务器更换或IP更换需要修改的地方

--捷信达服务器更换或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')

landv / landv.github.io

捷信达服务器更换或IP更换需要修改的地方 #72