摘要:
// /// EXCEL数据转换DataSet/// /// 文件全路径/// 表名/// private DataSet GetDataSet(string fileName){string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data So... 阅读全文
摘要:
STUFF((SELECT '+'+m.MProjectName FROM dbo.Maintenance m WITH(NOLOCK) WHERE m.ID IN(SELECT item FROM dbo.Split(cs.MIDs,',')) FOR XML PATH('')),1,1,''), 阅读全文