酱香蜜雪粮液

摘要： 测试表 测试参数 DECLARE @return_value int, @vmax_waterno bigint EXEC @return_value = [dbo].[get_waterno] @vtableName = N'testtable', @vcnt = 1, @vmax_waterno 阅读全文

摘要： Windows server 2008服务器部署： DotNetCore.1.0.0.RC2-WindowsHosting 或者DotNetCore.1.0.5_1.1.2-WindowsHosting.exe Redis-x64-3.2.100.msi Windows6.1-KB2533623-x 阅读全文

摘要： jdbc:oracle:thin:@(DESCRIPTION=(failover=on)(enable=broken)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.110.120.10)(PORT=1521))(LOAD_BALANCE=yes))(C 阅读全文

摘要： 严重: Exception starting filter StrutsPrepareFilterUnable to load configuration. - [unknown location] 出现这种错误 jar包冲突 xerce.jar和xml-apis.jar这两个jar包冲突 或者是类 阅读全文

摘要： 必须要有字母和数字,且至少有一个大写字母的js正则表达式如下 /^(?=.*?[A-Za-z]+)(?=.*?[0-9]+)(?=.*?[A-Z]).*$/ 纯数字或纯英文，所以这个正则不符合要求。 这个正确的正则应该是: ^(?![0-9]+$)(?![a-zA-Z]+$)[0-9A-Za-z]{ 阅读全文

摘要： set @stsqlReplace=' update ChgCfm set cfmdate=replace(cfmdate,'''''''',''''), cfmstatu=replace(cfmstatu,'''''''','''') '; exec sp_executesql @statReplace=@stsqlReplace; 阅读全文

摘要： update CfmRcd set reconsource=replace(reconsource,'''',''), cmffile =replace(cmffile,'''',''), cfmdate=replace(cfmdate,'''',''),'20170721' 阅读全文

摘要： select convert(datetime,substring(left('20170719172552',8)+' ' + substring('20170719172552',9,2)+':' + substring('20170719172552',11,2)+':' + substring('20170719172552',13,2),1,20))select substring('... 阅读全文

摘要： MySQL： UPDATE ChgCfm t1 INNER JOIN tb_dz_file t2 ON t1.ID = t2.ID SET t1.CfmStatus =0 WHERE t1.CmfFile ='001' SQLserver: UPDATE t1 SET t1.CfmStatus=0 FROM ChgCfmRcd t1 ... 阅读全文

摘要： Oracle： select LPAD(number_no,20,'0') from dual select LPAD(3,20,'0') from dual 效果：000000000000000000003 Mssql: select replicate('0',20)+ltrim(tt.number_no) from Tabletest as tt 效果：00000000000... 阅读全文