摘要:
由于工作原因要熟悉这两门编程语言。网上找的。VB.NETProgram StructureC#Imports System Namespace Hello Class HelloWorld Overloads Shared SubMain(ByVal args() As String) Dim na... 阅读全文
摘要:
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... 阅读全文