ASP.net , C#, and VB.net , and Java, and SQL

摘要： The declaration of a delegate type takes the following form: Copy The delegate keyword is used to declare a reference type that can be used to encapsulate a named or an anonymous method. Delegates a... 阅读全文

摘要： All types and type members have an accessibility level, which controls whether they can be used from other code in your assembly or other assemblies. You can use the following access modifiers to sp... 阅读全文

摘要： The internal keyword is an access modifier for types and type members. Internal types or members are accessible only within files in the same assembly, as in this example:[代码] [代码] For a comparison ... 阅读全文

摘要： Fundamentals of Structures 代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--structInteger{privateintval;publicintValue{get{returnval;}set{val=value;}... 阅读全文

摘要： Substring(EmailAddress, 0, Charindex('@',EmailAddress)) 阅读全文

摘要： select * INTO #tmpMarkFROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\******(import on 20101124).xls;HDR=YES', ' SELECT * FROM [*****$]') AS TINNER JOIN AS S ON COLLATE Chinese_PRC_90... 阅读全文

摘要： ISNULL(CAST(isnotf.aa AS VARCHAR), '') 阅读全文

摘要： 关于SQL查询，有学生和班级两张表。查询班级人数大于50的班级的所有信息SELECT 班级.IDFROM 班级, 学生WHERE 班级.ID = 学生.所属班级IDGROUP BY 班级.IDHAVING COUNT(学生.ID) > 50上面的SQL, 只获取班级人数大于50的班级的 ID 阅读全文

摘要： 表格字段：科室ID，姓名ID，分组，数量表格数据：Dept_A ，U1，G1， 20； Dept_A ，U1，G2， 5； Dept_B ，U1，G1， 3； Dept_B ，U1，G2， 0；要实现的效果： 科室ID，姓名ID，G1的数量，G2的数量 Dept_A ，U1， 20 ， 5 ； Dept_B ，U1， 3 ， 0 ；其实就是把分组和数量两列横向展示， select 科室ID,姓名I... 阅读全文

摘要： Insert Into TableName_1 (column_1, column_2......) Values select column_1, column_2..... form TableName_2Update set tablename_1.column_1=tablename_2.column_1From tablename_1 Inner Join tablename_2 on... 阅读全文