- 博客(3)
- 资源 (9)
- 问答 (1)
- 收藏
- 关注
原创 Access中实现GroupConcat效果
T_EdwinT_EdwinIDNameRole1王楠部门经理2张乐营销主任3张乐市场推广员4欧阳华技术主管建立如上的表,并添加如下的函数:Public Function GroupConcat(sColumn As String, sTable As String, Optional sCriteria As String, Optional sDelimiter As String = ",") On Error GoTo ErrHandler Dim rs As New ADO
2011-03-26 20:30:00 6444 1
原创 获得分组内容的前N条记录
实现效果: SELECT Authorid,Author,Message FROM ( SELECT A.Authorid,A.Author,A.Message, IF(@Author=A.Author,@rank:=@rank+1,@rank:=1) AS rank, @Author:=A.Author FROM ( SELECT Authorid,Author,Message FROM t_authorm ORDER BY A
2011-03-19 20:34:00 751
原创 SSIS导出数据到EXCEL【调用的目标发生了异常。 (mscorlib) 】
<br />异常描述:<br /><br />解决方式:<br /> <br /> <br />改成本地系统即可。这样做虽然解决了此问题,但是又带来了新的安全问题。<br /> <br />
2011-03-17 10:02:00 3080
TA创建的收藏夹 TA关注的收藏夹
TA关注的人