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

[landv]

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