摘要:
连接字符串 CONCATENATE("UPDATE dbo.PingDingItem SET ItemCode='",C2,"',Pinyin='",B2,"' WHERE Name='",A2,"';") CONCATENATE("INSERT INTO dbo.PingDingItem(Name 阅读全文
摘要:
public static class h { public static List<string> GetFieldNames(this SqlDataReader dr) { var list = new List<string>(); for (var i = 0; i < dr.FieldC 阅读全文
摘要:
1,新建存储过程名称 2,传入变量 3,声明变量(declare)如果需要的话 4,逻辑 CREATE PROC sp_UpdateByID @PId INT,@Id INT AS BEGIN declare @Pidx int SELECT TOP 1 @Pidx=Pidx FROM aa WHE 阅读全文
摘要:
http://www.my97.net/demo/index.htm https://blog.csdn.net/xiangff_csdn/article/details/78688506 SELECT * FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY p.C 阅读全文
摘要:
//四舍五入方法 public static class DecimalHelper { public static decimal CutDecimalWithN(decimal d, int n) { string strDecimal = d.ToString(); int index = s 阅读全文