m0_50623581的博客

;with sql1 as(select a.sysserialno,a.FailDetailReason,a.StationName, a.CreateDT, row_number() over(partition by a.sysserialno, a.stationname order by a.createdt desc) as num from mfsystestresult a where a.sysserialno in('FX213050001B9','FX213060002AN')

UPDATE mfsyscserial WITH(ROWLOCK) set sysserialno=a.sysserialno+'-RW' +convert(varchar(10),b.NUM), cserialno =a.cserialno + '-RW' + CONVERT(VARCHAR, (SELECT count (*) from mfsyscserial WHERE cserialno like ('ACM042T08D' + '-RW%')).

ALTER FUNCTION [dbo].[fn_AlgorismToOther](@BaseString VARCHAR(50),@Value BIGINT,@StringLength INT)RETURNS varchar(50)AS --select dbo.fn_AlgorismToOther ('0123456789abcdef',52185+1,8) as mBEGIN DECLARE @m_ReturnString varchar(50), @m_Base .

private void btnUpdate_Click(object sender, EventArgs e) { List<string> listFileName = Directory.GetFiles(@AppConfig.FilePath).ToList(); StringBuilder text = new StringBuilder(); bool twoLine = false; ..

最近在优化一个存储过程，存储执行太慢，且没有用递归写法，我负责改成递归形式@SourceSSNDataInfo是一个表变量第0阶，之前是这么写的INSERT INTO @SourceSSNDataInfoSELECT '00' AS 'Level',--Level '' AS 'ParentSysSSN',--ParentSysSSN '' AS 'ParentActualSSN',--Paren

一次开发dppm值经历需求如下代码： SELECT failurepartno, Count(1) num FROM sfcrepairpart r LEFT JOIN Sfcrepairmain m ON r.sysserialno = m.sysserialno AND r.lineseqno = m.lineseqno WHERE LEFT(m.sysse