摘要： ''' ''' 邮箱代码 ''' ''' 收件人地址 ''' 收件人名字 ''' 抄送人 ''' 密件抄送人 ''' 主题 ''' 正文 ''' 不返回 ''' Public Shared Sub senderemail(ByVal toaddress As String, ByVal toname As String, ByVal 阅读全文

摘要： 1.with 用法with SubQuery(ID,Name,parenetid,[Level]) as ( select ID,Name,parenetid,0 as [Level] from test where isnull(parenetid ,0)= 0 union all select A.ID,A.Name,A.parenetid,B.Level+1 AS [Level] from test A inner join SubQuery B on A.parenetid = B.ID ) select * from SubQuery2.SQL c... 阅读全文