摘要:
public static string StructSql(int startYear, int startMonth, int endYear, int endMonth) { StringBuilder tempSql = new StringBuilder(); DateTime dtStart = new DateTime(startYear, startMonth, 1); DateT... 阅读全文
摘要:
一句话解决更新和插入的问题 if exists(select 1 from Pat_ResultScores where SID=:SID) update Pat_ResultScores set Scores=:Scores,UserY=:UserY,UserP=:UserP where SID=:SID else insert into Pat_ResultScores(SID,Scores,... 阅读全文