摘要:
--分割符转列select ParsedData.* from new_systemparameterbase mt cross apply ( select str = mt.New_value + ',,' ) f1 cross apply ( select p1 = charindex( ',', str ) ) ap1 cross apply ( select p... 阅读全文
摘要:
//方式1Date.prototype.DateAdd = function(interval, number, date) { switch (interval) { case "y": { date.setFullYear(date.getFullYear() + number); return date; break; } case "m": { date.setMonth(date.get 阅读全文
摘要:
摘自:https://blog.csdn.net/weixin_34309435/article/details/86030675 阅读全文
摘要:
SELECT STUFF( (SELECT ';' + name FROM tbtable WHERE id='88799089-076A-4E96-9D0A-7CFD72CF3D08' FOR XML PATH('') ),1, 1, '') 阅读全文
摘要:
using System; using System.Collections.Generic; using System.IO; using System.Net; using System.Net.Security; using System.Security.Cryptography.X509Certificates; using System.Text; using System.Web;... 阅读全文
摘要:
public class AsynUdpClient { /// <summary> /// 回调委托 /// </summary> /// <param name="point">ip</param> /// <param name="msg"></param> public delegate v 阅读全文
摘要:
select * from( SELECT row_number() over(PARTITION BY productid ORDER BY sort,Price) as number,* from productattr where flag=false )x WHERE NUMBER=1 阅读全文
摘要:
编码规则:符合日期、流水、自定义特定常量@v都可使用 例如: C-02001-{yy}CQC{0000}@v CQCNL{yyyy}CB{0000} CE-02001-{yy}CQC{0000} C-02001-{yy}CCRC{0000} V-02001-{yy}CQC{0000} W-{0000 阅读全文
摘要:
第一种方式普通循环取值 CREATE FUNCTION [dbo].[f_split] ( @string VARCHAR(MAX) , @separator CHAR ) RETURNS @return TABLE ( value VARCHAR(200) ) AS BEGIN DECLARE @ 阅读全文
摘要:
//3.客户端 //4.web 阅读全文