- 博客(6)
- 收藏
- 关注
转载 根据结果集 合并字符串
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
88
转载 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
671
转载 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
63
转载 按指定时间段分组统计
http://www.cnblogs.com/jhxk/articles/1639384.html#undefined转载于:https://www.cnblogs.com/kunEssay/p/5997252.html
2016-10-25 16:42:00
273
转载 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
77
转载 SQL日期转换
SQL 语句日期用法及函数--DAY()、MONTH()、YEAR()——返回指定日期的天数、月数、年数;select day(cl_s_time) as '日' fromclass--返回天select '月'=month(cl_s_time) fromclass--返回月select '年'=year(cl_s_time) from class--...
2016-08-01 17:35:00
120
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人