恋恋风尘

摘要：举个例子~UPDATE e SET e.money = e.money + d.amountFROM employee e INNER JOIN (SELECT empid,amount=sum(amount) FROM deleted WHERE rechargeable=1 GROUP BY empid) d ON d.empid=e.id 阅读全文

摘要：Public Sub BuildExcel() '写入内容到Excel Dim hssfworkbook As HSSFWorkbook = WriteExcel() Dim destFileName As String = "D:\test.xls" Dim msfile As New MemoryStream() hssfworkbook.Write(msfile) System.IO.File.WriteAllBytes(destFileName, msfile.ToArray()) En... 阅读全文