- 博客(6)
- 收藏
- 关注
RSS订阅转载 根据结果集 合并字符串
SELECT OutBoundLinId, STUFF((SELECT distinct ';' + RecCode FROM FI_ARReceivableSheets tleft join FI_ARReceiSheetLines t2 ON t.ReceivableSheetId = t2.ReceivableSheetId WHERE t2.OutBoundLinId=FI_A...
2017-05-26 17:19:00
127
转载 winform 写入和读取TXT文件
C# winform写入和读取TXT文件 string str; str=this.textBox1.Text; StreamWriter sw = new StreamWriter(Application.StartupPath +"\\txtwriter.txt", false); sw.WriteLine(str)...
2016-12-14 13:56:00
726
转载 XML与DataSet的相互转换的类
一、XML与DataSet的相互转换的类 using System; using System.Collections.Generic; using System.Text; using System.Data; using System.IO; using System.Xml; namespace XmlDesign { ...
2016-12-13 10:23:00
97
转载 按指定时间段分组统计
http://www.cnblogs.com/jhxk/articles/1639384.html#undefined 转载于:https://www.cnblogs.com/kunEssay/p/5997252.html
2016-10-25 16:42:00
308
转载 SQL 截取字符
select SUBSTRING('123,abcdefg',charindex(',','123,abcdefg',0)+1,LEN('123,abcdefg')-charindex(',','123,abcdefg',0)) select SUBSTRING('123,abcdefg',0,charindex(',','123,abcdefg',0)) 转载于:htt...
2016-08-01 17:41:00
118
转载 SQL日期转换
SQL 语句日期用法及函数 --DAY()、MONTH()、YEAR()——返回指定日期的天数、月数、年数； select day(cl_s_time) as '日' from class--返回天 select '月'=month(cl_s_time) from class--返回月 select '年'=year(cl_s_time) from class--...
2016-08-01 17:35:00
156
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人